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. For information about hiding source text, see sp_hidetext in the Reference Manual.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
