This topic has not yet been rated - Rate this topic

ServerEvent Class

SQL Server 2012

The ServerEvent object represents the SQL Server server events that can be included in a server event set.

System.Object
Microsoft.SqlServer.Management.Smo.ServerEvent

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

C++

JScript

'Declaration
Public NotInheritable Class ServerEvent
'Usage
Dim instance As ServerEvent

The ServerEvent type exposes the following members.

Properties

	Name	Description
	AddRoleMember	Gets a server event that can be included in the event set.
	AddServerRoleMember	Gets a server event that can be included in the event set.
	AddSignature	Gets a server event that can be included in the event set.
	AddSignatureSchemaObject	Gets a server event that can be included in the event set.
	AlterApplicationRole	Gets a server event that can be included in the event set.
	AlterAssembly	Gets a server event that can be included in the event set.
	AlterAsymmetricKey	Gets a server event that can be included in the event set.
	AlterAuthorizationDatabase	Gets a server event that can be included in the event set.
	AlterAuthorizationServer	Gets a server event that can be included in the event set.
	AlterAvailabilityGroup	Gets a server event that can be included in the event set.
	AlterBrokerPriority	Gets a server event that can be included in the event set.
	AlterCertificate	Gets a server event that can be included in the event set.
	AlterCredential	Gets a server event that can be included in the event set.
	AlterCryptographicProvider	Gets a server event that can be included in the event set.
	AlterDatabase	Gets a server event that can be included in the event set.
	AlterDatabaseAuditSpecification	Gets a server event that can be included in the event set.
	AlterDatabaseEncryptionKey	Gets a server event that can be included in the event set.
	AlterEndpoint	Gets a server event that can be included in the event set.
	AlterEventSession	Gets a server event that can be included in the event set.
	AlterExtendedProperty	Gets a server event that can be included in the event set.
	AlterFulltextCatalog	Gets a server event that can be included in the event set.
	AlterFulltextIndex	Gets a server event that can be included in the event set.
	AlterFulltextStoplist	Gets a server event that can be included in the event set.
	AlterFunction	Gets a server event that can be included in the event set.
	AlterIndex	Gets a server event that can be included in the event set.
	AlterInstance	Gets a server event that can be included in the event set.
	AlterLinkedServer	Gets a server event that can be included in the event set.
	AlterLogin	Gets a server event that can be included in the event set.
	AlterMasterKey	Gets a server event that can be included in the event set.
	AlterMessage	Gets a server event that can be included in the event set.
	AlterMessageType	Gets a server event that can be included in the event set.
	AlterPartitionFunction	Gets a server event that can be included in the event set.
	AlterPartitionScheme	Gets a server event that can be included in the event set.
	AlterPlanGuide	Gets a server event that can be included in the event set.
	AlterProcedure	Gets a server event that can be included in the event set.
	AlterQueue	Gets a server event that can be included in the event set.
	AlterRemoteServer	Gets a server event that can be included in the event set.
	AlterRemoteServiceBinding	Gets a server event that can be included in the event set.
	AlterResourceGovernorConfig	Gets a server event that can be included in the event set.
	AlterResourcePool	Gets a server event that can be included in the event set.
	AlterRole	Gets a server event that can be included in the event set.
	AlterRoute	Gets a server event that can be included in the event set.
	AlterSchema	Gets a server event that can be included in the event set.
	AlterSearchPropertyList	Gets a server event that can be included in the event set.
	AlterSequence	Gets a server event that can be included in the event set.
	AlterServerAudit	Gets a server event that can be included in the event set.
	AlterServerAuditSpecification	Gets a server event that can be included in the event set.
	AlterServerConfiguration	Gets a server event that can be included in the event set.
	AlterServerRole	Gets a server event that can be included in the event set.
	AlterService	Gets a server event that can be included in the event set.
	AlterServiceMasterKey	Gets a server event that can be included in the event set.
	AlterSymmetricKey	Gets a server event that can be included in the event set.
	AlterTable	Gets a server event that can be included in the event set.
	AlterTrigger	Gets a server event that can be included in the event set.
	AlterUser	Gets a server event that can be included in the event set.
	AlterView	Gets a server event that can be included in the event set.
	AlterWorkloadGroup	Gets a server event that can be included in the event set.
	AlterXmlSchemaCollection	Gets a server event that can be included in the event set.
	BindDefault	Gets a server event that can be included in the event set.
	BindRule	Gets a server event that can be included in the event set.
	CreateApplicationRole	Gets a server event that can be included in the event set.
	CreateAssembly	Gets a server event that can be included in the event set.
	CreateAsymmetricKey	Gets a server event that can be included in the event set.
	CreateAvailabilityGroup	Gets a server event that can be included in the event set.
	CreateBrokerPriority	Gets a server event that can be included in the event set.
	CreateCertificate	Gets a server event that can be included in the event set.
	CreateContract	Gets a server event that can be included in the event set.
	CreateCredential	Gets a server event that can be included in the event set.
	CreateCryptographicProvider	Gets a server event that can be included in the event set.
	CreateDatabase	Gets a server event that can be included in the event set.
	CreateDatabaseAuditSpecification	Gets a server event that can be included in the event set.
	CreateDatabaseEncryptionKey	Gets a server event that can be included in the event set.
	CreateDefault	Gets a server event that can be included in the event set.
	CreateEndpoint	Gets a server event that can be included in the event set.
	CreateEventNotification	Gets a server event that can be included in the event set.
	CreateEventSession	Gets a server event that can be included in the event set.
	CreateExtendedProcedure	Gets a server event that can be included in the event set.
	CreateExtendedProperty	Gets a server event that can be included in the event set.
	CreateFulltextCatalog	Gets a server event that can be included in the event set.
	CreateFulltextIndex	Gets a server event that can be included in the event set.
	CreateFulltextStoplist	Gets a server event that can be included in the event set.
	CreateFunction	Gets a server event that can be included in the event set.
	CreateIndex	Gets a server event that can be included in the event set.
	CreateLinkedServer	Gets a server event that can be included in the event set.
	CreateLinkedServerLogin	Gets a server event that can be included in the event set.
	CreateLogin	Gets a server event that can be included in the event set.
	CreateMasterKey	Gets a server event that can be included in the event set.
	CreateMessage	Gets a server event that can be included in the event set.
	CreateMessageType	Gets a server event that can be included in the event set.
	CreatePartitionFunction	Gets a server event that can be included in the event set.
	CreatePartitionScheme	Gets a server event that can be included in the event set.
	CreatePlanGuide	Gets a server event that can be included in the event set.
	CreateProcedure	Gets a server event that can be included in the event set.
	CreateQueue	Gets a server event that can be included in the event set.
	CreateRemoteServer	Gets a server event that can be included in the event set.
	CreateRemoteServiceBinding	Gets a server event that can be included in the event set.
	CreateResourcePool	Gets a server event that can be included in the event set.
	CreateRole	Gets a server event that can be included in the event set.
	CreateRoute	Gets a server event that can be included in the event set.
	CreateRule	Gets a server event that can be included in the event set.
	CreateSchema	Gets a server event that can be included in the event set.
	CreateSearchPropertyList	Gets a server event that can be included in the event set.
	CreateSequence	Gets a server event that can be included in the event set.
	CreateServerAudit	Gets a server event that can be included in the event set.
	CreateServerAuditSpecification	Gets a server event that can be included in the event set.
	CreateServerRole	Gets a server event that can be included in the event set.
	CreateService	Gets a server event that can be included in the event set.
	CreateSpatialIndex	Gets a server event that can be included in the event set.
	CreateStatistics	Gets a server event that can be included in the event set.
	CreateSymmetricKey	Gets a server event that can be included in the event set.
	CreateSynonym	Gets a server event that can be included in the event set.
	CreateTable	Gets a server event that can be included in the event set.
	CreateTrigger	Gets a server event that can be included in the event set.
	CreateType	Gets a server event that can be included in the event set.
	CreateUser	Gets a server event that can be included in the event set.
	CreateView	Gets a server event that can be included in the event set.
	CreateWorkloadGroup	Gets a server event that can be included in the event set.
	CreateXmlIndex	Gets a server event that can be included in the event set.
	CreateXmlSchemaCollection	Gets a server event that can be included in the event set.
	DenyDatabase	Gets a server event that can be included in the event set.
	DenyServer	Gets a server event that can be included in the event set.
	DropApplicationRole	Gets a server event that can be included in the event set.
	DropAssembly	Gets a server event that can be included in the event set.
	DropAsymmetricKey	Gets a server event that can be included in the event set.
	DropAvailabilityGroup	Gets a server event that can be included in the event set.
	DropBrokerPriority	Gets a server event that can be included in the event set.
	DropCertificate	Gets a server event that can be included in the event set.
	DropContract	Gets a server event that can be included in the event set.
	DropCredential	Gets a server event that can be included in the event set.
	DropCryptographicProvider	Gets a server event that can be included in the event set.
	DropDatabase	Gets a server event that can be included in the event set.
	DropDatabaseAuditSpecification	Gets a server event that can be included in the event set.
	DropDatabaseEncryptionKey	Gets a server event that can be included in the event set.
	DropDefault	Gets a server event that can be included in the event set.
	DropEndpoint	Gets a server event that can be included in the event set.
	DropEventNotification	Gets a server event that can be included in the event set.
	DropEventSession	Gets a server event that can be included in the event set.
	DropExtendedProcedure	Gets a server event that can be included in the event set.
	DropExtendedProperty	Gets a server event that can be included in the event set.
	DropFulltextCatalog	Gets a server event that can be included in the event set.
	DropFulltextIndex	Gets a server event that can be included in the event set.
	DropFulltextStoplist	Gets a server event that can be included in the event set.
	DropFunction	Gets a server event that can be included in the event set.
	DropIndex	Gets a server event that can be included in the event set.
	DropLinkedServer	Gets a server event that can be included in the event set.
	DropLinkedServerLogin	Gets a server event that can be included in the event set.
	DropLogin	Gets a server event that can be included in the event set.
	DropMasterKey	Gets a server event that can be included in the event set.
	DropMessage	Gets a server event that can be included in the event set.
	DropMessageType	Gets a server event that can be included in the event set.
	DropPartitionFunction	Gets a server event that can be included in the event set.
	DropPartitionScheme	Gets a server event that can be included in the event set.
	DropPlanGuide	Gets a server event that can be included in the event set.
	DropProcedure	Gets a server event that can be included in the event set.
	DropQueue	Gets a server event that can be included in the event set.
	DropRemoteServer	Gets a server event that can be included in the event set.
	DropRemoteServiceBinding	Gets a server event that can be included in the event set.
	DropResourcePool	Gets a server event that can be included in the event set.
	DropRole	Gets a server event that can be included in the event set.
	DropRoleMember	Gets a server event that can be included in the event set.
	DropRoute	Gets a server event that can be included in the event set.
	DropRule	Gets a server event that can be included in the event set.
	DropSchema	Gets a server event that can be included in the event set.
	DropSearchPropertyList	Gets a server event that can be included in the event set.
	DropSequence	Gets a server event that can be included in the event set.
	DropServerAudit	Gets a server event that can be included in the event set.
	DropServerAuditSpecification	Gets a server event that can be included in the event set.
	DropServerRole	Gets a server event that can be included in the event set.
	DropServerRoleMember	Gets a server event that can be included in the event set.
	DropService	Gets a server event that can be included in the event set.
	DropSignature	Gets a server event that can be included in the event set.
	DropSignatureSchemaObject	Gets a server event that can be included in the event set.
	DropStatistics	Gets a server event that can be included in the event set.
	DropSymmetricKey	Gets a server event that can be included in the event set.
	DropSynonym	Gets a server event that can be included in the event set.
	DropTable	Gets a server event that can be included in the event set.
	DropTrigger	Gets a server event that can be included in the event set.
	DropType	Gets a server event that can be included in the event set.
	DropUser	Gets a server event that can be included in the event set.
	DropView	Gets a server event that can be included in the event set.
	DropWorkloadGroup	Gets a server event that can be included in the event set.
	DropXmlSchemaCollection	Gets a server event that can be included in the event set.
	GrantDatabase	Gets a server event that can be included in the event set.
	GrantServer	Gets a server event that can be included in the event set.
	Rename	Gets a server event that can be included in the event set.
	RevokeDatabase	Gets a server event that can be included in the event set.
	RevokeServer	Gets a server event that can be included in the event set.
	UnbindDefault	Gets a server event that can be included in the event set.
	UnbindRule	Gets a server event that can be included in the event set.
	UpdateStatistics	Gets a server event that can be included in the event set.

Top

Methods

	Name	Description
	Add	Returns a server event set after adding a new server event to the event set.
	BitwiseOr	Returns a ServerEventSet as a result of a bitwise OR operation on two ServerEvent objects.
	Equals	Determines whether the referenced server event object is equal to a specified object. (Overrides Object.Equals(Object).)
	GetHashCode	Do not reference this member directly in your code. It supports the SQL Server infrastructure.Serves as a hash function, suitable for use in hashing algorithms and data structures like a hash table. (Overrides Object.GetHashCode.)
	GetType	(Inherited from Object.)
	ToString	Returns the referenced object in string format. (Overrides Object.ToString.)

Top

Operators

	Name	Description
	Addition	Creates a server event set by performing an addition operation on two ServerEvent objects.
	BitwiseOr	Creates a server event set by performing a bitwise OR operation on two ServerEvent objects.
	Equality	Creates a server event set by performing an equality operation on two ServerEvent objects.
	Widening(ServerEvent to ServerEventSet)	Creates a server event set by performing an implicit operation on a ServerEvent object.
	Inequality	Creates a server event set by performing an inequality operation on two ServerEvent objects.

Top

Remarks

The ServerEvent object contains a property for each event to which the instance of SQL Server can respond. The actual set of events is specified using the ServerEventSet object.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.

Examples

Handling SMO Events

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Reference

Microsoft.SqlServer.Management.Smo Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD