sys-numbered-procedures-transact-sql.md

title	sys.numbered_procedures (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/15/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	sys.numbered_procedures_TSQL numbered_procedures sys.numbered_procedures numbered_procedures_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.numbered_procedures catalog view
ms.assetid	5b6d6498-bac6-4266-94b9-d16ef5089cf0
caps.latest.revision	18
author	BYHAM
ms.author	rickbyh
manager	jhubbard

sys.numbered_procedures (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-asdw-pdw_md]

Contains a row for each SQL Server stored procedure that was created as a numbered procedure. This does not show a row for the base (number = 1) stored procedure. Entries for the base stored procedures can be found in views such as sys.objects and sys.procedures.

Important

Numbered procedures are deprecated. Use of numbered procedures is discouraged. A DEPRECATION_ANNOUNCEMENT event is fired when a query that uses this catalog view is compiled.

Column name	Data type	Description
object_id	int	ID of the object of the stored procedure.
procedure_number	smallint	Number of this procedure within the object, 2 or greater.
definition	nvarchar(max)	The SQL Server text that defines this procedure. NULL = encrypted.

Note

XML and CLR parameters are not supported for numbered procedures.

Permissions

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

See Also

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