Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2008 R2
Product Documentation
SQL Server 2008 R2 Books Online
Database Engine
Technical Reference
SQL Server Management Objects (SMO) Class Library
Microsoft.SqlServer.Management.Smo Namespace
ServerEventSet Class
ServerEventSet Properties
AddRoleMember Property
AddServerRoleMember Property
AddSignature Property
AddSignatureSchemaObject Property
AlterApplicationRole Property
AlterAssembly Property
AlterAsymmetricKey Property
AlterAuthorizationDatabase Property
AlterAuthorizationServer Property
AlterBrokerPriority Property
AlterCertificate Property
AlterCredential Property
AlterCryptographicProvider Property
AlterDatabase Property
AlterDatabaseAuditSpecification Property
AlterDatabaseEncryptionKey Property
AlterEndpoint Property
AlterEventSession Property
AlterExtendedProperty Property
AlterFulltextCatalog Property
AlterFulltextIndex Property
AlterFulltextStoplist Property
AlterFunction Property
AlterIndex Property
AlterInstance Property
AlterLinkedServer Property
AlterLogin Property
AlterMasterKey Property
AlterMessage Property
AlterMessageType Property
AlterPartitionFunction Property
AlterPartitionScheme Property
AlterPlanGuide Property
AlterProcedure Property
AlterQueue Property
AlterRemoteServer Property
AlterRemoteServiceBinding Property
AlterResourceGovernorConfig Property
AlterResourcePool Property
AlterRole Property
AlterRoute Property
AlterSchema Property
AlterServerAudit Property
AlterServerAuditSpecification Property
AlterServerConfiguration Property
AlterService Property
AlterServiceMasterKey Property
AlterSymmetricKey Property
AlterTable Property
AlterTrigger Property
AlterUser Property
AlterView Property
AlterWorkloadGroup Property
AlterXmlSchemaCollection Property
BindDefault Property
BindRule Property
CreateApplicationRole Property
CreateAssembly Property
CreateAsymmetricKey Property
CreateBrokerPriority Property
CreateCertificate Property
CreateContract Property
CreateCredential Property
CreateCryptographicProvider Property
CreateDatabase Property
CreateDatabaseAuditSpecification Property
CreateDatabaseEncryptionKey Property
CreateDefault Property
CreateEndpoint Property
CreateEventNotification Property
CreateEventSession Property
CreateExtendedProcedure Property
CreateExtendedProperty Property
CreateFulltextCatalog Property
CreateFulltextIndex Property
CreateFulltextStoplist Property
CreateFunction Property
CreateIndex Property
CreateLinkedServer Property
CreateLinkedServerLogin Property
CreateLogin Property
CreateMasterKey Property
CreateMessage Property
CreateMessageType Property
CreatePartitionFunction Property
CreatePartitionScheme Property
CreatePlanGuide Property
CreateProcedure Property
CreateQueue Property
CreateRemoteServer Property
CreateRemoteServiceBinding Property
CreateResourcePool Property
CreateRole Property
CreateRoute Property
CreateRule Property
CreateSchema Property
CreateServerAudit Property
CreateServerAuditSpecification Property
CreateService Property
CreateSpatialIndex Property
CreateStatistics Property
CreateSymmetricKey Property
CreateSynonym Property
CreateTable Property
CreateTrigger Property
CreateType Property
CreateUser Property
CreateView Property
CreateWorkloadGroup Property
CreateXmlIndex Property
CreateXmlSchemaCollection Property
DenyDatabase Property
DenyServer Property
DropApplicationRole Property
DropAssembly Property
DropAsymmetricKey Property
DropBrokerPriority Property
DropCertificate Property
DropContract Property
DropCredential Property
DropCryptographicProvider Property
DropDatabase Property
DropDatabaseAuditSpecification Property
DropDatabaseEncryptionKey Property
DropDefault Property
DropEndpoint Property
DropEventNotification Property
DropEventSession Property
DropExtendedProcedure Property
DropExtendedProperty Property
DropFulltextCatalog Property
DropFulltextIndex Property
DropFulltextStoplist Property
DropFunction Property
DropIndex Property
DropLinkedServer Property
DropLinkedServerLogin Property
DropLogin Property
DropMasterKey Property
DropMessage Property
DropMessageType Property
DropPartitionFunction Property
DropPartitionScheme Property
DropPlanGuide Property
DropProcedure Property
DropQueue Property
DropRemoteServer Property
DropRemoteServiceBinding Property
DropResourcePool Property
DropRole Property
DropRoleMember Property
DropRoute Property
DropRule Property
DropSchema Property
DropServerAudit Property
DropServerAuditSpecification Property
DropServerRoleMember Property
DropService Property
DropSignature Property
DropSignatureSchemaObject Property
DropStatistics Property
DropSymmetricKey Property
DropSynonym Property
DropTable Property
DropTrigger Property
DropType Property
DropUser Property
DropView Property
DropWorkloadGroup Property
DropXmlSchemaCollection Property
GrantDatabase Property
GrantServer Property
NumberOfElements Property
Rename Property
RevokeDatabase Property
RevokeServer Property
UnbindDefault Property
UnbindRule Property
UpdateStatistics Property
Expand Minimize
This topic has not yet been rated - Rate this topic

ServerEventSet.DropRole Property

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a role is dropped.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.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.
If False (default), the event is not included in the event set.
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.