Displays the currently defined extended stored procedures and the name of the dynamic-link library to which the function belongs.
sp_helpextendedproc [function_name]
where
When function_name is specified, sp_helpextendedproc reports on the specified extended stored procedure. When no parameter is supplied, sp_helpextendedproc reports on all extended stored procedures.
This example reports on all extended stored procedures.
sp_helpextendedproc
This example reports on the xp_cmdshell extended stored procedure.
sp_helpextendedproc xp_cmdshell
Execute permission defaults to the system administrator and can be transferred.
syscomments, sysobjects
sp_addextendedproc | sp_dropextendedproc |