StoredProcedureEventSet 類別

The StoredProcedureEventSet object represents a set of stored procedure events.

繼承階層

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

命名空間：  Microsoft.SqlServer.Management.Smo
組件：  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
Public NotInheritable Class StoredProcedureEventSet _
    Inherits EventSetBase
'用途
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

StoredProcedureEventSet 型別公開下列成員。

建構函式

	名稱	說明
	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.

上層

屬性

	名稱	說明
	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. (覆寫 EventSetBase.NumberOfElements。)
	Storage	Gets or sets the bit array for event set storage. (繼承自 EventSetBase。)

上層

方法

	名稱	說明
	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. (覆寫 EventSetBase.Copy()。)
	Equals	(繼承自 Object。)
	GetHashCode	(繼承自 Object。)
	GetType	(繼承自 Object。)
	Remove	Removes an event from the event set.
	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. (覆寫 Object.ToString()。)

上層

運算子

	名稱	說明
	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.

上層

備註

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

此型別的任何公用靜態 (在 Microsoft Visual Basic 為共用) 成員具備多執行緒作業安全。並非所有的執行個體成員都是安全執行緒。

範例

處理 SMO 事件

執行緒安全性

這個型別的任何公用 static (在 Visual Basic 中為 Shared) 成員都是執行緒安全的。並不是所有的執行個體成員都保證可以用於所有的執行緒。

請參閱

參考

Microsoft.SqlServer.Management.Smo 命名空間