StoredProcedureEventSet StoredProcedureEventSet StoredProcedureEventSet Class

Definition

The StoredProcedureEventSet object represents a set of stored procedure events.

public ref class StoredProcedureEventSet sealed : Microsoft::SqlServer::Management::Smo::EventSetBase
public sealed class StoredProcedureEventSet : Microsoft.SqlServer.Management.Smo.EventSetBase
Public NotInheritable Class StoredProcedureEventSet
Inherits EventSetBase
Inheritance
StoredProcedureEventSetStoredProcedureEventSetStoredProcedureEventSet

Examples

Handling SMO Events

Remarks

SQL Server provides events subscriptions for all SMO objects that have server event support. The StoredProcedure object has event support for the events that are represented by StoredProcedureEventSet properties.

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.

Constructors

StoredProcedureEventSet() StoredProcedureEventSet() StoredProcedureEventSet()

Initializes a new instance of the StoredProcedureEventSet class.

StoredProcedureEventSet(StoredProcedureEvent) StoredProcedureEventSet(StoredProcedureEvent) StoredProcedureEventSet(StoredProcedureEvent)

Initializes a new instance of the StoredProcedureEventSet class with a specified event.

StoredProcedureEventSet(StoredProcedureEventSet) StoredProcedureEventSet(StoredProcedureEventSet) StoredProcedureEventSet(StoredProcedureEventSet)

Initializes a new instance of the StoredProcedureEventSet class with a specified set of events.

StoredProcedureEventSet(StoredProcedureEvent[]) StoredProcedureEventSet(StoredProcedureEvent[]) StoredProcedureEventSet(StoredProcedureEvent[])

Initializes a new instance of the StoredProcedureEventSet class with a specified set of events.

Properties

AlterProcedure AlterProcedure 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.

DropProcedure DropProcedure 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.

NumberOfElements NumberOfElements NumberOfElements

Gets the number of events in the event set.

Storage Storage Storage

Gets or sets the bit array for event set storage.

(Inherited from EventSetBase)

Methods

Add(StoredProcedureEvent) Add(StoredProcedureEvent) Add(StoredProcedureEvent)

Returns a set of stored procedure events after adding a new stored procedure event to the referenced event set.

Add(StoredProcedureEventSet, StoredProcedureEvent) Add(StoredProcedureEventSet, StoredProcedureEvent) Add(StoredProcedureEventSet, StoredProcedureEvent)

Returns a set of stored procedure events after adding a new stored procedure event to the specified event set.

Copy() Copy() Copy()

Returns a copy of the event set.

FitsMask(EventSetBase) FitsMask(EventSetBase) FitsMask(EventSetBase)

Specifies whether the EventSetBase object fits the specified mask.

(Inherited from EventSetBase)
HasCommonBits(EventSetBase) HasCommonBits(EventSetBase) HasCommonBits(EventSetBase)

Specifies whether the EventSetBase object has common bits with another specified EventSetBase object.

(Inherited from EventSetBase)
Remove(StoredProcedureEvent) Remove(StoredProcedureEvent) Remove(StoredProcedureEvent)

Removes an event from the event set.

SetValue(EventSetBase, Boolean) SetValue(EventSetBase, Boolean) SetValue(EventSetBase, Boolean)

Sets the bit value at the specified index position.

(Inherited from EventSetBase)
Subtract(StoredProcedureEventSet, StoredProcedureEvent) Subtract(StoredProcedureEventSet, StoredProcedureEvent) Subtract(StoredProcedureEventSet, StoredProcedureEvent)

Returns a set of stored procedure events after subtracting a stored procedure event from the specified event set.

ToString() ToString() ToString()

Returns a string that represents the StoredProcedureEventSet object.

Operators

Addition(StoredProcedureEventSet, StoredProcedureEvent) Addition(StoredProcedureEventSet, StoredProcedureEvent) Addition(StoredProcedureEventSet, StoredProcedureEvent)

Creates a stored procedure event set by performing an addition operation on a StoredProcedureEvent object and a StoredProcedureEventSet object.

Subtraction(StoredProcedureEventSet, StoredProcedureEvent) Subtraction(StoredProcedureEventSet, StoredProcedureEvent) Subtraction(StoredProcedureEventSet, StoredProcedureEvent)

Creates a stored procedure event set by performing a subtraction operation on a StoredProcedureEvent object and a StoredProcedureEventSet object.

Applies to