Displays extended stored procedures (ESPs) in the current database, along with their associated DLL files.
sp_helpextendedproc [esp_name]
is the name of the extended stored procedure. It must be a procedure in the current database.
Lists the xp_cmdshell ESP and the name of the DLL file in which its function is stored:
use sybsystemprocs go sp_helpextendedproc xp_cmdshell
ESP Name DLL Name ----------- ---------- xp_cmdshell sybsyesp
Lists all the ESPs in the current database, along with the names of the DLL files in which their functions are stored:
sp_helpextendedproc
ESP Name DLL Name ----------- ---------- xp_freedl sybsyesp xp_cmdshell sybsyesp
If the esp_name is omitted, sp_helpextendedproc lists all the extended stored procedures in the database.
The esp_name is case sensitive. It must match the esp_name used to create the ESP.
Only a System Administrator can execute sp_helpextendedproc to see all the ESPs in the database. All users can execute sp_helpextendedproc to see ESPs owned by themselves or by the Database Owner.
Values in event and extrainfo columns from the sysaudits table are:
Event |
Audit option |
Command or access audited |
Information in extrainfo |
---|---|---|---|
38 |
exec_procedure |
Execution of a procedure |
|
Commands create procedure, drop procedure
Extended system procedure xp_cmdshell
System procedures sp_addextendedproc, sp_dropextendedproc
Copyright © 2005. Sybase Inc. All rights reserved. |