DatabaseEventSet Members

  • Article

The DatabaseEventSet object represents a Microsoft SQL Server set of database events.

The following tables list the members exposed by the DatabaseEventSet type.

Public Constructors

  Name Description
DatabaseEventSet Overloaded. Initializes a new instance of the DatabaseEventSet class.

Top

Public Properties

(see also Protected Properties )

  Name Description
ms219351.pubproperty(en-US,SQL.90).gif AddRoleMember Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a member is added to a database role in the database.
ms219351.pubproperty(en-US,SQL.90).gif AlterApplicationRole Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an application role is altered in the database.
ms219351.pubproperty(en-US,SQL.90).gif AlterAssembly Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an assembly is altered in the database.
ms219351.pubproperty(en-US,SQL.90).gif AlterAuthorizationDatabase Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when the authorization database is altered.
ms219351.pubproperty(en-US,SQL.90).gif AlterCertificate Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a certificate is altered in the database.
ms219351.pubproperty(en-US,SQL.90).gif AlterFunction Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a user-defined function is altered in the database.
ms219351.pubproperty(en-US,SQL.90).gif AlterIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an index is altered in the database.
ms219351.pubproperty(en-US,SQL.90).gif AlterMessageType Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a message type is altered in the database.
ms219351.pubproperty(en-US,SQL.90).gif AlterPartitionFunction Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition function is altered in the database.
ms219351.pubproperty(en-US,SQL.90).gif AlterPartitionScheme Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition scheme is altered in the database.
ms219351.pubproperty(en-US,SQL.90).gif AlterProcedure 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.
ms219351.pubproperty(en-US,SQL.90).gif AlterQueue Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker queue is altered in the database.
ms219351.pubproperty(en-US,SQL.90).gif AlterRemoteServiceBinding Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a remote service binding is altered in the database.
ms219351.pubproperty(en-US,SQL.90).gif AlterRole 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 altered in the database.
ms219351.pubproperty(en-US,SQL.90).gif AlterRoute Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker route is altered in the database.
ms219351.pubproperty(en-US,SQL.90).gif AlterSchema Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a schema is altered in the database.
ms219351.pubproperty(en-US,SQL.90).gif AlterService Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker service is altered in the database.
ms219351.pubproperty(en-US,SQL.90).gif AlterTable Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a table is altered in the database.
ms219351.pubproperty(en-US,SQL.90).gif AlterTrigger Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a trigger is altered in the database.
ms219351.pubproperty(en-US,SQL.90).gif AlterUser Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database user is altered in the database.
ms219351.pubproperty(en-US,SQL.90).gif AlterView Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a view is altered in the database.
ms219351.pubproperty(en-US,SQL.90).gif AlterXmlSchemaCollection Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an XML schema collection is altered in the database.
ms219351.pubproperty(en-US,SQL.90).gif CreateApplicationRole Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an application role is created in the database.
ms219351.pubproperty(en-US,SQL.90).gif CreateAssembly Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an assembly is created in the database.
ms219351.pubproperty(en-US,SQL.90).gif CreateCertificate Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a certificate is created in the database.
ms219351.pubproperty(en-US,SQL.90).gif CreateContract Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker contract is created in the database.
ms219351.pubproperty(en-US,SQL.90).gif CreateEventNotification Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an event notification is created in the database.
ms219351.pubproperty(en-US,SQL.90).gif CreateFunction Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a user-defined function is created in the database.
ms219351.pubproperty(en-US,SQL.90).gif CreateIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an index is created in the database.
ms219351.pubproperty(en-US,SQL.90).gif CreateMessageType Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a message type is created in the database.
ms219351.pubproperty(en-US,SQL.90).gif CreatePartitionFunction Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition function is created in the database.
ms219351.pubproperty(en-US,SQL.90).gif CreatePartitionScheme Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition scheme is created in the database.
ms219351.pubproperty(en-US,SQL.90).gif CreateProcedure 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 created in the database.
ms219351.pubproperty(en-US,SQL.90).gif CreateQueue Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker queue is created in the database.
ms219351.pubproperty(en-US,SQL.90).gif CreateRemoteServiceBinding Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a remote service binding is created in the database.
ms219351.pubproperty(en-US,SQL.90).gif CreateRole 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 created in the database.
ms219351.pubproperty(en-US,SQL.90).gif CreateRoute Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker route is created in the database.
ms219351.pubproperty(en-US,SQL.90).gif CreateSchema Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a schema is created in the database.
ms219351.pubproperty(en-US,SQL.90).gif CreateService Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker service is created in the database.
ms219351.pubproperty(en-US,SQL.90).gif CreateStatistics Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a statistics counter is created in the database.
ms219351.pubproperty(en-US,SQL.90).gif CreateSynonym Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a synonym is created in the database.
ms219351.pubproperty(en-US,SQL.90).gif CreateTable Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a table is created in the database.
ms219351.pubproperty(en-US,SQL.90).gif CreateTrigger Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a trigger is created in the database.
ms219351.pubproperty(en-US,SQL.90).gif CreateType Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a type is created in the database.
ms219351.pubproperty(en-US,SQL.90).gif CreateUser Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database user is created in the database.
ms219351.pubproperty(en-US,SQL.90).gif CreateView Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a view is created in the database.
ms219351.pubproperty(en-US,SQL.90).gif CreateXmlIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an XML index is created in the database.
ms219351.pubproperty(en-US,SQL.90).gif CreateXmlSchemaCollection Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an XML schema collection is created in the database.
ms219351.pubproperty(en-US,SQL.90).gif DenyDatabase Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when access the database is denied.
ms219351.pubproperty(en-US,SQL.90).gif DropApplicationRole Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an application role is dropped from the database.
ms219351.pubproperty(en-US,SQL.90).gif DropAssembly Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an assembly is dropped from the database.
ms219351.pubproperty(en-US,SQL.90).gif DropCertificate Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a certificate is dropped from the database.
ms219351.pubproperty(en-US,SQL.90).gif DropContract Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker contract is dropped from the database.
ms219351.pubproperty(en-US,SQL.90).gif DropDatabase Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when the database is dropped.
ms219351.pubproperty(en-US,SQL.90).gif DropEventNotification Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an event notification is dropped from the database.
ms219351.pubproperty(en-US,SQL.90).gif DropFunction Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a user-defined function is dropped from the database.
ms219351.pubproperty(en-US,SQL.90).gif DropIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an index is dropped from the database.
ms219351.pubproperty(en-US,SQL.90).gif DropMessageType Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a message type is dropped from the database.
ms219351.pubproperty(en-US,SQL.90).gif DropPartitionFunction Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition function is dropped from the database.
ms219351.pubproperty(en-US,SQL.90).gif DropPartitionScheme Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition scheme is dropped from the database.
ms219351.pubproperty(en-US,SQL.90).gif DropProcedure 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 dropped from the database.
ms219351.pubproperty(en-US,SQL.90).gif DropQueue Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker queue is dropped from the database.
ms219351.pubproperty(en-US,SQL.90).gif DropRemoteServiceBinding Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a remote service binding is dropped from the database.
ms219351.pubproperty(en-US,SQL.90).gif DropRole 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 from the database.
ms219351.pubproperty(en-US,SQL.90).gif DropRoleMember Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a member is dropped from a database role in the database.
ms219351.pubproperty(en-US,SQL.90).gif DropRoute Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker route is dropped from the database.
ms219351.pubproperty(en-US,SQL.90).gif DropSchema Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a schema is dropped from the database.
ms219351.pubproperty(en-US,SQL.90).gif DropService Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker service is dropped from the database.
ms219351.pubproperty(en-US,SQL.90).gif DropStatistics Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a statistics counter is dropped from the database.
ms219351.pubproperty(en-US,SQL.90).gif DropSynonym Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a synonym is dropped from the database.
ms219351.pubproperty(en-US,SQL.90).gif DropTable Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a table is dropped from the database.
ms219351.pubproperty(en-US,SQL.90).gif DropTrigger Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a trigger is dropped from the database.
ms219351.pubproperty(en-US,SQL.90).gif DropType Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a type is dropped from the database.
ms219351.pubproperty(en-US,SQL.90).gif DropUser Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database user is dropped from the database.
ms219351.pubproperty(en-US,SQL.90).gif DropView Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a view is dropped from the database.
ms219351.pubproperty(en-US,SQL.90).gif DropXmlSchemaCollection Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an XML schema collection is dropped from the database.
ms219351.pubproperty(en-US,SQL.90).gif GrantDatabase Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when access is granted to the database.
ms219351.pubproperty(en-US,SQL.90).gif NumberOfElements Overridden. Gets the number of events included in the event set.
ms219351.pubproperty(en-US,SQL.90).gif RevokeDatabase Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when access to the database is revoked.
ms219351.pubproperty(en-US,SQL.90).gif UpdateStatistics Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when the statistics are updated in the database.

Top

Protected Properties

  Name Description
ms219351.protproperty(en-US,SQL.90).gif Storage  Gets or sets the bit array for event set storage. (inherited from EventSetBase)

Top

Public Methods

(see also Protected Methods )

  Name Description
ms219351.pubmethod(en-US,SQL.90).gif Add Overloaded. Returns a set of database events after adding a new database event to the event set.
ms219351.pubmethod(en-US,SQL.90).gif Copy Overridden. Returns a copy of the DatabaseEventSet object.
ms219351.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from Object )
ms219351.pubmethod(en-US,SQL.90).gif GetHashCode  (inherited from Object )
ms219351.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms219351.pubmethod(en-US,SQL.90).gifms219351.static(en-US,SQL.90).gif op_Addition Creates a database event set by performing an addition operation on a DatabaseEvent object and a DatabaseEventSet object.
ms219351.pubmethod(en-US,SQL.90).gifms219351.static(en-US,SQL.90).gif op_Subtraction Creates a database event set by performing a subtraction operation on a DatabaseEvent object and a DatabaseEventSet object.
ms219351.pubmethod(en-US,SQL.90).gifms219351.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms219351.pubmethod(en-US,SQL.90).gif Remove Removes an event from the event set.
ms219351.pubmethod(en-US,SQL.90).gifms219351.static(en-US,SQL.90).gif Subtract Returns a set of database events after removing a database event from the specified event set.
ms219351.pubmethod(en-US,SQL.90).gif ToString Overridden. Returns a string that represents the DatabaseEventSet object.

Top

Protected Methods

  Name Description
ms219351.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms219351.protmethod(en-US,SQL.90).gif FitsMask  (inherited from EventSetBase )
ms219351.protmethod(en-US,SQL.90).gif HasCommonBits  (inherited from EventSetBase )
ms219351.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )
ms219351.protmethod(en-US,SQL.90).gif SetValue  (inherited from EventSetBase )

Top

See Also

Reference

DatabaseEventSet Class
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Handling SMO Events