Querying Extended Stored Procedures Installed in SQL Server
Applies to: SQL Server
Important
This feature will be removed in a future version of 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 Microsoft SQL Server authenticated user 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, the following example returns the DLL to which xp_hello belongs:
sp_helpextendedproc 'xp_hello'
If sp_helpextendedproc is executed without specifying an extended stored procedure, all the extended stored procedures and their DLLs are displayed.
Important
Information will be returned for only those extended stored procedures that the logged in user owns or has permissions to. Only members of the sysadmin fixed server role and the db_owner, db_securityadmin, and the db_ddladmin fixed database roles can view information for all extended stored procedures.
See Also
sp_helpextendedproc (Transact-SQL)
sp_addextendedproc (Transact-SQL)
sp_dropextendedproc (Transact-SQL)
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for