Getting information about ESPs

Use sp_helpextendedproc to get information about ESPs registered in the current database.

With no parameters, sp_helpextendedproc displays all the ESPs in the database, with the names of the DLLs containing their associated functions. With an ESP name as a parameter, it provides this information only for the specified ESP.

sp_helpextendedproc getmsgs 
ESP Name   DLL   
--------   --------- 
getmsgs    msgs.dll

Since the system ESPs are in the sybsystemprocs database, you must be using the sybsystemprocs database to display their names and DLLs:

use sybsystemprocs
sp_helpextendedproc
ESP Name     DLL   
--------     --------- 
xp_freedll   sybyesp
xp_cmdshell  sybyesp

If the source text of an ESP was encrypted using sp_hidetext, Adaptive Server displays a message advising you that the text is hidden. See the Reference Manual: Procedures.