sys-extended-procedures-transact-sql.md

title	sys.extended_procedures (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql
ms.prod_service	database-engine
ms.service
ms.component	system-catalog-views
ms.reviewer
ms.suite	sql
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	extended_procedures sys.extended_procedures sys.extended_procedures_TSQL extended_procedures_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.extended_procedures catalog view
ms.assetid	310e0f87-0044-4fdf-bd12-51a723a74ce6
caps.latest.revision	33
author	edmacauley
ms.author	edmaca
manager	craigg
ms.workload	Inactive

sys.extended_procedures (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

Contains a row for each object that is an extended stored procedure, with sys.objects.type = X. Because extended stored procedures are installed into the master database, they are only visible from that database context. Selecting from the sys.extended_procedures view in any other database context will return an empty result set.

Column name	Data type	Description
<Columns inherited from sys.objects>		For a list of columns that this view inherits, see sys.objects (Transact-SQL).
dll_name	nvarchar(260)	Name, including path, of the DLL for this extended stored procedure.

Permissions

[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.

See Also

Object Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)