The procedural functions that contain the ESP code are compiled and linked into dynamic link libraries (DLLs), which are loaded into XP Server memory in response to an ESP execution request. The library remains loaded unless:
XP Server exits
The sp_freedll system procedure is invoked
The esp unload dll configuration parameter is set using sp_configure
