Export (0) Print
Expand All

Querying Extended Stored Procedures Installed in SQL Server

SQL Server 2000

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:

sp_helpextendedproc 'xp_hello'

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.

See Also


© 2014 Microsoft