Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

StoredProcedureEventSet Class

The StoredProcedureEventSet object represents a set of stored procedure events.

System.Object
  Microsoft.SqlServer.Management.Smo.EventSetBase
    Microsoft.SqlServer.Management.Smo.StoredProcedureEventSet

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
public sealed class StoredProcedureEventSet : EventSetBase

The StoredProcedureEventSet type exposes the following members.

  NameDescription
Public methodStoredProcedureEventSet()Initializes a new instance of the StoredProcedureEventSet class.
Public methodStoredProcedureEventSet(StoredProcedureEvent)Initializes a new instance of the StoredProcedureEventSet class with a specified event.
Public methodStoredProcedureEventSet(StoredProcedureEvent[])Initializes a new instance of the StoredProcedureEventSet class with a specified set of events.
Public methodStoredProcedureEventSet(StoredProcedureEventSet)Initializes a new instance of the StoredProcedureEventSet class with a specified set of events.
Top
  NameDescription
Public propertyAlterProcedureGets 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.
Public propertyDropProcedureGets 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.
Public propertyNumberOfElementsGets the number of events in the event set. (Overrides EventSetBase.NumberOfElements.)
Protected propertyStorageGets or sets the bit array for event set storage. (Inherited from EventSetBase.)
Top
  NameDescription
Public methodAdd(StoredProcedureEvent)Returns a set of stored procedure events after adding a new stored procedure event to the referenced event set.
Public methodStatic memberAdd(StoredProcedureEventSet, StoredProcedureEvent)Returns a set of stored procedure events after adding a new stored procedure event to the specified event set.
Public methodCopyReturns a copy of the event set. (Overrides EventSetBase.Copy().)
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Protected methodFitsMaskSpecifies whether the EventSetBase object fits the specified mask. (Inherited from EventSetBase.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Protected methodHasCommonBitsSpecifies whether the EventSetBase object has common bits with another specified EventSetBase object. (Inherited from EventSetBase.)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodRemoveRemoves an event from the event set.
Protected methodSetValueSets the bit value at the specified index position. (Inherited from EventSetBase.)
Public methodStatic memberSubtractReturns a set of stored procedure events after subtracting a stored procedure event from the specified event set.
Public methodToStringReturns a string that represents the StoredProcedureEventSet object. (Overrides Object.ToString().)
Top
  NameDescription
Public operatorStatic memberAdditionCreates a stored procedure event set by performing an addition operation on a StoredProcedureEvent object and a StoredProcedureEventSet object.
Public operatorStatic memberSubtractionCreates a stored procedure event set by performing a subtraction operation on a StoredProcedureEvent object and a StoredProcedureEventSet object.
Top

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.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.