SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2012
Product Documentation
Developer Reference for SQL Server 2012
Developer Reference
Developer's Guide (Database Engine)
SQL Server Management Objects
SQL Server Management Objects Reference
Microsoft.SqlServer.Management.Smo
DatabaseEventSet Class
DatabaseEventSet Properties
AddRoleMember Property
AddSignature Property
AddSignatureSchemaObject Property
AlterApplicationRole Property
AlterAssembly Property
AlterAsymmetricKey Property
AlterAuthorizationDatabase Property
AlterBrokerPriority Property
AlterCertificate Property
AlterDatabaseAuditSpecification Property
AlterDatabaseEncryptionKey Property
AlterExtendedProperty Property
AlterFulltextCatalog Property
AlterFulltextIndex Property
AlterFulltextStoplist Property
AlterFunction Property
AlterIndex Property
AlterMasterKey Property
AlterMessageType Property
AlterPartitionFunction Property
AlterPartitionScheme Property
AlterPlanGuide Property
AlterProcedure Property
AlterQueue Property
AlterRemoteServiceBinding Property
AlterRole Property
AlterRoute Property
AlterSchema Property
AlterSearchPropertyList Property
AlterSequence Property
AlterService Property
AlterSymmetricKey Property
AlterTable Property
AlterTrigger Property
AlterUser Property
AlterView Property
AlterXmlSchemaCollection Property
BindDefault Property
BindRule Property
CreateApplicationRole Property
CreateAssembly Property
CreateAsymmetricKey Property
CreateBrokerPriority Property
CreateCertificate Property
CreateContract Property
CreateDatabaseAuditSpecification Property
CreateDatabaseEncryptionKey Property
CreateDefault Property
CreateEventNotification Property
CreateExtendedProperty Property
CreateFulltextCatalog Property
CreateFulltextIndex Property
CreateFulltextStoplist Property
CreateFunction Property
CreateIndex Property
CreateMasterKey Property
CreateMessageType Property
CreatePartitionFunction Property
CreatePartitionScheme Property
CreatePlanGuide Property
CreateProcedure Property
CreateQueue Property
CreateRemoteServiceBinding Property
CreateRole Property
CreateRoute Property
CreateRule Property
CreateSchema Property
CreateSearchPropertyList Property
CreateSequence Property
CreateService Property
CreateSpatialIndex Property
CreateStatistics Property
CreateSymmetricKey Property
CreateSynonym Property
CreateTable Property
CreateTrigger Property
CreateType Property
CreateUser Property
CreateView Property
CreateXmlIndex Property
CreateXmlSchemaCollection Property
DenyDatabase Property
DropApplicationRole Property
DropAssembly Property
DropAsymmetricKey Property
DropBrokerPriority Property
DropCertificate Property
DropContract Property
DropDatabase Property
DropDatabaseAuditSpecification Property
DropDatabaseEncryptionKey Property
DropDefault Property
DropEventNotification Property
DropExtendedProperty Property
DropFulltextCatalog Property
DropFulltextIndex Property
DropFulltextStoplist Property
DropFunction Property
DropIndex Property
DropMasterKey Property
DropMessageType Property
DropPartitionFunction Property
DropPartitionScheme Property
DropPlanGuide Property
DropProcedure Property
DropQueue Property
DropRemoteServiceBinding Property
DropRole Property
DropRoleMember Property
DropRoute Property
DropRule Property
DropSchema Property
DropSearchPropertyList Property
DropSequence Property
DropService Property
DropSignature Property
DropSignatureSchemaObject Property
DropStatistics Property
DropSymmetricKey Property
DropSynonym Property
DropTable Property
DropTrigger Property
DropType Property
DropUser Property
DropView Property
DropXmlSchemaCollection Property
GrantDatabase Property
NumberOfElements Property
Rename Property
RevokeDatabase Property
UnbindDefault Property
UnbindRule Property
UpdateStatistics Property
Expand Minimize
This topic has not yet been rated - Rate this topic

DatabaseEventSet.AlterProcedure Property

SQL Server 2012

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a stored procedure is altered in the database.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
C#
C++
F#
JScript
VB
Copy 
public bool AlterProcedure { get; set; }

Property Value

Type: System.Boolean
A Boolean value that specifies whether the AlterProcedure event is included in the event set. If True, the event is included in the event set. Otherwise, False.
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.