Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Querying Extended Stored Procedures Installed in SQL Server

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

sp_helpextendedproc

Show:
© 2015 Microsoft