Querying Extended Stored Procedures Installed in SQL Server
A Microsoft® SQL Server™ system administrator can display the currently defined extended stored procedures and the name of the DLL to which each belongs by running the sp_helpextendedproc system procedure. For example, this command returns the DLL to which xp_hello belongs:
This is in a sample only available if you select Dev Tools during setup.
If sp_helpextendedproc is executed without specifying an extended stored procedure, then all the extended stored procedures and their DLLs are displayed.