New system procedures for ESPs

Table 5-13 lists the system procedures that support ESPs.

Table 5-13: New system procedures for ESP

System Procedure

Description

sp_addextendedproc

Creates an ESP.

sp_configure

"esp execution priority"

Sets the priority of the XP Server thread for ESP execution.

"esp execution stacksize"

Sets the size of the stack, in bytes, to allocate for ESP execution.

"esp unload dll"

Specifies whether DLLs that support ESPs should automatically be unloaded from XP Server memory after the ESP call has completed.

"xp_cmdshell_context"

Sets the security context for the operating system command to be executed using the xp_cmdshell system ESP.

sp_dropextendedproc

Drops an ESP.

sp_freedll

Unloads a DLL that was loaded into XP Server memory to support the execution of an ESP.

sp_helpextendedproc

Displays ESPs in the current database with their associated DLL files.