StoredProcedureEventSet-Klasse

The StoredProcedureEventSet object represents a set of stored procedure events.

Vererbungshierarchie

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

'Declaration
Public NotInheritable Class StoredProcedureEventSet _
    Inherits EventSetBase
'Usage
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

Der StoredProcedureEventSet-Typ macht folgende Elemente verfügbar.

Konstruktoren

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

Zum Anfang

Eigenschaften

	Name	Beschreibung
	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	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	Gets the number of events in the event set. (Überschreibt EventSetBase. . :: . .NumberOfElements.)
	Storage	Gets or sets the bit array for event set storage. (Geerbt von EventSetBase.)

Zum Anfang

Methoden

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

Zum Anfang

Operatoren

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

Zum Anfang

Hinweise

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

Alle öffentlichen, statischen Elemente dieses Typs (Shared in Microsoft Visual Basic) sind für Vorgänge mit mehreren Threads sicher. Für Instanzelemente kann nicht sichergestellt werden, dass sie für Threads sicher sind.

Beispiele

Behandeln von SMO-Ereignissen

Threadsicherheit

Alle öffentlichen static (Shared in Visual Basic)-Elemente dieses Typs sind Threadsicher. Für Instanzelemente wird die Threadsicherheit nicht gewährleistet.

Siehe auch

Verweis

Microsoft.SqlServer.Management.Smo-Namespace