StoredProcedureEventSet Class
TOC
Collapse the table of content
Expand the table of content

StoredProcedureEventSet Class

 

The StoredProcedureEventSet object represents a set of stored procedure events.

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

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

public sealed class StoredProcedureEventSet : EventSetBase

NameDescription
System_CAPS_pubmethodStoredProcedureEventSet()

Initializes a new instance of the StoredProcedureEventSet class.

System_CAPS_pubmethodStoredProcedureEventSet(StoredProcedureEvent)

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

System_CAPS_pubmethodStoredProcedureEventSet(StoredProcedureEvent[])

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

System_CAPS_pubmethodStoredProcedureEventSet(StoredProcedureEventSet)

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

NameDescription
System_CAPS_pubpropertyAlterProcedure

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.

System_CAPS_pubpropertyDropProcedure

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.

System_CAPS_pubpropertyNumberOfElements

Gets the number of events in the event set.(Overrides EventSetBase.NumberOfElements.)

System_CAPS_protpropertyStorage

Gets or sets the bit array for event set storage. (Inherited from EventSetBase.)

NameDescription
System_CAPS_pubmethodAdd(StoredProcedureEvent)

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

System_CAPS_pubmethodSystem_CAPS_staticAdd(StoredProcedureEventSet, StoredProcedureEvent)

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

System_CAPS_pubmethodCopy()

Returns a copy of the event set.(Overrides EventSetBase.Copy().)

System_CAPS_pubmethodEquals(Object)

(Inherited from Object.)

System_CAPS_pubmethodGetHashCode()

(Inherited from Object.)

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_pubmethodRemove(StoredProcedureEvent)

Removes an event from the event set.

System_CAPS_pubmethodSystem_CAPS_staticSubtract(StoredProcedureEventSet, StoredProcedureEvent)

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

System_CAPS_pubmethodToString()

Returns a string that represents the StoredProcedureEventSet object.(Overrides Object.ToString().)

NameDescription
System_CAPS_puboperatorSystem_CAPS_staticAddition(StoredProcedureEventSet, StoredProcedureEvent)

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

System_CAPS_puboperatorSystem_CAPS_staticSubtraction(StoredProcedureEventSet, StoredProcedureEvent)

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

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.

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.

Return to top
Show:
© 2016 Microsoft