This topic has not yet been rated - Rate this topic

DatabaseEvent Class

SQL Server 2012

SQL Server 2005

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

System.Object
Microsoft.SqlServer.Management.Smo.DatabaseEvent

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

Syntax

C++

JScript

public sealed class DatabaseEvent

The DatabaseEvent type exposes the following members.

Properties

	Name	Description
	AddRoleMember	Gets a database event that can be included in the event set.
	AddSignature	Gets a database event that can be included in the event set.
	AddSignatureSchemaObject	Gets a database event that can be included in the event set.
	AlterApplicationRole	Gets a database event that can be included in the event set.
	AlterAssembly	Gets a database event that can be included in the event set.
	AlterAsymmetricKey	Gets a database event that can be included in the event set.
	AlterAuthorizationDatabase	Gets a database event that can be included in the event set.
	AlterBrokerPriority	Gets a database event that can be included in the event set.
	AlterCertificate	Gets a database event that can be included in the event set.
	AlterDatabaseAuditSpecification	Gets a database event that can be included in the event set.
	AlterDatabaseEncryptionKey	Gets a database event that can be included in the event set.
	AlterExtendedProperty	Gets a database event that can be included in the event set.
	AlterFulltextCatalog	Gets a database event that can be included in the event set.
	AlterFulltextIndex	Gets a database event that can be included in the event set.
	AlterFulltextStoplist	Gets a database event that can be included in the event set.
	AlterFunction	Gets a database event that can be included in the event set.
	AlterIndex	Gets a database event that can be included in the event set.
	AlterMasterKey	Gets a database event that can be included in the event set.
	AlterMessageType	Gets a database event that can be included in the event set.
	AlterPartitionFunction	Gets a database event that can be included in the event set.
	AlterPartitionScheme	Gets a database event that can be included in the event set.
	AlterPlanGuide	Gets a database event that can be included in the event set.
	AlterProcedure	Gets a database event that can be included in the event set.
	AlterQueue	Gets a database event that can be included in the event set.
	AlterRemoteServiceBinding	Gets a database event that can be included in the event set.
	AlterRole	Gets a database event that can be included in the event set.
	AlterRoute	Gets a database event that can be included in the event set.
	AlterSchema	Gets a database event that can be included in the event set.
	AlterSearchPropertyList	Gets a database event that can be included in the event set.
	AlterSequence	Gets a database event that can be included in the event set.
	AlterService	Gets a database event that can be included in the event set.
	AlterSymmetricKey	Gets a database event that can be included in the event set.
	AlterTable	Gets a database event that can be included in the event set.
	AlterTrigger	Gets a database event that can be included in the event set.
	AlterUser	Gets a database event that can be included in the event set.
	AlterView	Gets a database event that can be included in the event set.
	AlterXmlSchemaCollection	Gets a database event that can be included in the event set.
	BindDefault	Gets a database event that can be included in the event set.
	BindRule	Gets a database event that can be included in the event set.
	CreateApplicationRole	Gets a database event that can be included in the event set.
	CreateAssembly	Gets a database event that can be included in the event set.
	CreateAsymmetricKey	Gets a database event that can be included in the event set.
	CreateBrokerPriority	Gets a database event that can be included in the event set.
	CreateCertificate	Gets a database event that can be included in the event set.
	CreateContract	Gets a database event that can be included in the event set.
	CreateDatabaseAuditSpecification	Gets a database event that can be included in the event set.
	CreateDatabaseEncryptionKey	Gets a database event that can be included in the event set.
	CreateDefault	Gets a database event that can be included in the event set.
	CreateEventNotification	Gets a database event that can be included in the event set.
	CreateExtendedProperty	Gets a database event that can be included in the event set.
	CreateFulltextCatalog	Gets a database event that can be included in the event set.
	CreateFulltextIndex	Gets a database event that can be included in the event set.
	CreateFulltextStoplist	Gets a database event that can be included in the event set.
	CreateFunction	Gets a database event that can be included in the event set.
	CreateIndex	Gets a database event that can be included in the event set.
	CreateMasterKey	Gets a database event that can be included in the event set.
	CreateMessageType	Gets a database event that can be included in the event set.
	CreatePartitionFunction	Gets a database event that can be included in the event set.
	CreatePartitionScheme	Gets a database event that can be included in the event set.
	CreatePlanGuide	Gets a database event that can be included in the event set.
	CreateProcedure	Gets a database event that can be included in the event set.
	CreateQueue	Gets a database event that can be included in the event set.
	CreateRemoteServiceBinding	Gets a database event that can be included in the event set.
	CreateRole	Gets a database event that can be included in the event set.
	CreateRoute	Gets a database event that can be included in the event set.
	CreateRule	Gets a database event that can be included in the event set.
	CreateSchema	Gets a database event that can be included in the event set.
	CreateSearchPropertyList	Gets a database event that can be included in the event set.
	CreateSequence	Gets a database event that can be included in the event set.
	CreateService	Gets a database event that can be included in the event set.
	CreateSpatialIndex	Gets a database event that can be included in the event set.
	CreateStatistics	Gets a database event that can be included in the event set.
	CreateSymmetricKey	Gets a database event that can be included in the event set.
	CreateSynonym	Gets a database event that can be included in the event set.
	CreateTable	Gets a database event that can be included in the event set.
	CreateTrigger	Gets a database event that can be included in the event set.
	CreateType	Gets a database event that can be included in the event set.
	CreateUser	Gets a database event that can be included in the event set.
	CreateView	Gets a database event that can be included in the event set.
	CreateXmlIndex	Gets a database event that can be included in the event set.
	CreateXmlSchemaCollection	Gets a database event that can be included in the event set.
	DenyDatabase	Gets a database event that can be included in the event set.
	DropApplicationRole	Gets a database event that can be included in the event set.
	DropAssembly	Gets a database event that can be included in the event set.
	DropAsymmetricKey	Gets a database event that can be included in the event set.
	DropBrokerPriority	Gets a database event that can be included in the event set.
	DropCertificate	Gets a database event that can be included in the event set.
	DropContract	Gets a database event that can be included in the event set.
	DropDatabase	Gets a database event that can be included in the event set.
	DropDatabaseAuditSpecification	Gets a database event that can be included in the event set.
	DropDatabaseEncryptionKey	Gets a database event that can be included in the event set.
	DropDefault	Gets a database event that can be included in the event set.
	DropEventNotification	Gets a database event that can be included in the event set.
	DropExtendedProperty	Gets a database event that can be included in the event set.
	DropFulltextCatalog	Gets a database event that can be included in the event set.
	DropFulltextIndex	Gets a database event that can be included in the event set.
	DropFulltextStoplist	Gets a database event that can be included in the event set.
	DropFunction	Gets a database event that can be included in the event set.
	DropIndex	Gets a database event that can be included in the event set.
	DropMasterKey	Gets a database event that can be included in the event set.
	DropMessageType	Gets a database event that can be included in the event set.
	DropPartitionFunction	Gets a database event that can be included in the event set.
	DropPartitionScheme	Gets a database event that can be included in the event set.
	DropPlanGuide	Gets a database event that can be included in the event set.
	DropProcedure	Gets a database event that can be included in the event set.
	DropQueue	Gets a database event that can be included in the event set.
	DropRemoteServiceBinding	Gets a database event that can be included in the event set.
	DropRole	Gets a database event that can be included in the event set.
	DropRoleMember	Gets a database event that can be included in the event set.
	DropRoute	Gets a database event that can be included in the event set.
	DropRule	Gets a database event that can be included in the event set.
	DropSchema	Gets a database event that can be included in the event set.
	DropSearchPropertyList	Gets a database event that can be included in the event set.
	DropSequence	Gets a database event that can be included in the event set.
	DropService	Gets a database event that can be included in the event set.
	DropSignature	Gets a database event that can be included in the event set.
	DropSignatureSchemaObject	Gets a database event that can be included in the event set.
	DropStatistics	Gets a database event that can be included in the event set.
	DropSymmetricKey	Gets a database event that can be included in the event set.
	DropSynonym	Gets a database event that can be included in the event set.
	DropTable	Gets a database event that can be included in the event set.
	DropTrigger	Gets a database event that can be included in the event set.
	DropType	Gets a database event that can be included in the event set.
	DropUser	Gets a database event that can be included in the event set.
	DropView	Gets a database event that can be included in the event set.
	DropXmlSchemaCollection	Gets a database event that can be included in the event set.
	GrantDatabase	Gets a database event that can be included in the event set.
	Rename	Gets a database event that can be included in the event set.
	RevokeDatabase	Gets a database event that can be included in the event set.
	UnbindDefault	Gets a database event that can be included in the event set.
	UnbindRule	Gets a database event that can be included in the event set.
	UpdateStatistics	Gets a database event that can be included in the event set.

Top

Methods

	Name	Description
	Add	Returns the database event set that was created by adding two database events together.
	BitwiseOr	Creates a database event set by performing a bitwise OR operation on two DatabaseEvent objects.
	Equals	Determines whether the referenced database 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. (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 database event set by performing an addition operation on two DatabaseEvent objects.
	BitwiseOr	Creates a database event set by performing a bitwise OR operation on two DatabaseEvent objects.
	Equality	Creates a database event set by performing an equality operation on two DatabaseEvent objects.
	Implicit(DatabaseEvent to DatabaseEventSet)	Creates a database event set by performing an implicit operation on a DatabaseEvent object.
	Inequality	Creates a database event set by performing an inequality operation on two DatabaseEvent objects.

Top

Remarks

The DatabaseEvent object contains a property for each event to which the database can respond. The actual set of events is specified by using the DatabaseEventSet 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