Reports the currently defined extended stored procedures and the name of the dynamic-link library (DLL) to which the procedure (function) belongs.
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use CLR Integration instead.
A. Reporting help on all extended stored procedures
The following example reports on all extended stored procedures.
USE master; GO EXEC sp_helpextendedproc; GO
B. Reporting help on a single extended stored procedure
The following example reports on the xp_cmdshell extended stored procedure.
USE master; GO EXEC sp_helpextendedproc xp_cmdshell; GO