querying-extended-stored-procedures-installed-in-sql-server.md

title	Querying extended stored procedures
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology
ms.topic	reference
helpviewer_keywords	extended stored procedures [SQL Server], querying
ms.assetid	e02348e6-dba6-438a-98b6-684244bb034d
author	rothja
ms.author	jroth
ms.custom	seo-dt-2019

Querying Extended Stored Procedures Installed in SQL Server

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]

Important

[!INCLUDEssNoteDepFutureDontUse] Use CLR integration instead.

A [!INCLUDEmsCoName] [!INCLUDEssNoVersion] 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)