Aracılığıyla paylaş


StoredProcedureEventSet Class

The StoredProcedureEventSet object represents a set of stored procedure events.

Inheritance Hierarchy

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)

Syntax

'Bildirim
Public NotInheritable Class StoredProcedureEventSet _
    Inherits EventSetBase
'Kullanım
Dim instance As StoredProcedureEventSet
public sealed class StoredProcedureEventSet : EventSetBase
public ref class StoredProcedureEventSet sealed : public EventSetBase
[<SealedAttribute>]
type StoredProcedureEventSet =  
    class
        inherit EventSetBase
    end
public final class StoredProcedureEventSet extends EventSetBase

The StoredProcedureEventSet type exposes the following members.

Constructors

  Name Description
Public method StoredProcedureEventSet() Initializes a new instance of the StoredProcedureEventSet class.
Public method StoredProcedureEventSet(StoredProcedureEvent) Initializes a new instance of the StoredProcedureEventSet class with a specified event.
Public method StoredProcedureEventSet(array<StoredProcedureEvent[]) Initializes a new instance of the StoredProcedureEventSet class with a specified set of events.
Public method StoredProcedureEventSet(StoredProcedureEventSet) Initializes a new instance of the StoredProcedureEventSet class with a specified set of events.

Top

Properties

  Name Description
Public property 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.
Public property 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.
Public property NumberOfElements Gets the number of events in the event set. (Overrides EventSetBase.NumberOfElements.)
Protected property Storage Gets or sets the bit array for event set storage. (Inherited from EventSetBase.)

Top

Methods

  Name Description
Public method Add(StoredProcedureEvent) Returns a set of stored procedure events after adding a new stored procedure event to the referenced event set.
Public methodStatic member Add(StoredProcedureEventSet, StoredProcedureEvent) Returns a set of stored procedure events after adding a new stored procedure event to the specified event set.
Public method Copy Returns a copy of the event set. (Overrides EventSetBase.Copy().)
Public method Equals (Inherited from Object.)
Protected method Finalize (Inherited from Object.)
Protected method FitsMask Specifies whether the EventSetBase object fits the specified mask. (Inherited from EventSetBase.)
Public method GetHashCode (Inherited from Object.)
Public method GetType (Inherited from Object.)
Protected method HasCommonBits Specifies whether the EventSetBase object has common bits with another specified EventSetBase object. (Inherited from EventSetBase.)
Protected method MemberwiseClone (Inherited from Object.)
Public method Remove Removes an event from the event set.
Protected method SetValue Sets the bit value at the specified index position. (Inherited from EventSetBase.)
Public methodStatic member Subtract Returns a set of stored procedure events after subtracting a stored procedure event from the specified event set.
Public method ToString Returns a string that represents the StoredProcedureEventSet object. (Overrides Object.ToString().)

Top

Operators

  Name Description
Public operatorStatic member Addition Creates a stored procedure event set by performing an addition operation on a StoredProcedureEvent object and a StoredProcedureEventSet object.
Public operatorStatic member Subtraction Creates a stored procedure event set by performing a subtraction operation on a StoredProcedureEvent object and a StoredProcedureEventSet object.

Top

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.

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.

See Also

Reference

Microsoft.SqlServer.Management.Smo Namespace