title
sys.procedures (Transact-SQL) | Microsoft Docs
ms.custom
ms.date
03/15/2017
ms.prod
sql-non-specified
ms.reviewer
ms.suite
ms.technology
ms.tgt_pltfrm
ms.topic
language-reference
f1_keywords
procedures
sys.procedures_TSQL
sys.procedures
procedures_TSQL
dev_langs
helpviewer_keywords
sys.procedures catalog view
ms.assetid
d17af274-b2dd-464e-9523-ee1f43e1455b
caps.latest.revision
20
author
BYHAM
ms.author
rickbyh
manager
jhubbard
sys.procedures (Transact-SQL) [!INCLUDEtsql-appliesto-ss2008-all_md ]
Contains a row for each object that is a procedure of some kind, with sys.objects.type = P, X, RF, and PC.
Column name
Data type
Description
<Columns inherited from sys.objects> For a list of columns that this view inherits, see sys.objects (Transact-SQL)
is_auto_executed bit 1 = Procedure is auto-executed at the server startup; otherwise, 0. Can only be set for procedures in the master database.
is_execution_replicated bit Execution of this procedure is replicated.
is_repl_serializable_only bit Replication of the procedure execution is done only when the transaction can be serialized.
skips_repl_constraints bit During execution, the procedure skips constraints marked NOT FOR REPLICATION.
[!INCLUDEssCatViewPerm ] For more information, see Metadata Visibility Configuration .
Object Catalog Views (Transact-SQL) Catalog Views (Transact-SQL)