Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
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
DatabaseDdlTriggerEventSet Class
DatabaseDdlTriggerEventSet 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
DdlApplicationRoleEventsEvents Property
DdlAssemblyEventsEvents Property
DdlAsymmetricKeyEventsEvents Property
DdlAuthorizationDatabaseEventsEvents Property
DdlBrokerPriorityEventsEvents Property
DdlCertificateEventsEvents Property
DdlContractEventsEvents Property
DdlCryptoSignatureEventsEvents Property
DdlDatabaseAuditSpecificationEventsEvents Property
DdlDatabaseEncryptionKeyEventsEvents Property
DdlDatabaseLevelEventsEvents Property
DdlDatabaseSecurityEventsEvents Property
DdlDefaultEventsEvents Property
DdlEventNotificationEventsEvents Property
DdlExtendedPropertyEventsEvents Property
DdlFulltextCatalogEventsEvents Property
DdlFulltextStoplistEventsEvents Property
DdlFunctionEventsEvents Property
DdlGdrDatabaseEventsEvents Property
DdlIndexEventsEvents Property
DdlMasterKeyEventsEvents Property
DdlMessageTypeEventsEvents Property
DdlPartitionEventsEvents Property
DdlPartitionFunctionEventsEvents Property
DdlPartitionSchemeEventsEvents Property
DdlPlanGuideEventsEvents Property
DdlProcedureEventsEvents Property
DdlQueueEventsEvents Property
DdlRemoteServiceBindingEventsEvents Property
DdlRoleEventsEvents Property
DdlRouteEventsEvents Property
DdlRuleEventsEvents Property
DdlSchemaEventsEvents Property
DdlSearchPropertyListEventsEvents Property
DdlSequenceEventsEvents Property
DdlServiceEventsEvents Property
DdlSsbEventsEvents Property
DdlStatisticsEventsEvents Property
DdlSymmetricKeyEventsEvents Property
DdlSynonymEventsEvents Property
DdlTableEventsEvents Property
DdlTableViewEventsEvents Property
DdlTriggerEventsEvents Property
DdlTypeEventsEvents Property
DdlUserEventsEvents Property
DdlViewEventsEvents Property
DdlXmlSchemaCollectionEventsEvents Property
DenyDatabase Property
Dirty Property
DropApplicationRole Property
DropAssembly Property
DropAsymmetricKey Property
DropBrokerPriority Property
DropCertificate Property
DropContract 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

DatabaseDdlTriggerEventSet.DropRole 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 database role is dropped.

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

Property Value

Type: System.Boolean
A Boolean value that specifies whether the DropRole 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.