StoredProcedureEvents Class
The StoredProcedureEvents object represents the settings that are required for SQL Server stored procedure event notification.
Inheritance Hierarchy
System.Object
Microsoft.SqlServer.Management.Smo.StoredProcedureEvents
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Class StoredProcedureEvents
'Usage
Dim instance As StoredProcedureEvents
public class StoredProcedureEvents
public ref class StoredProcedureEvents
type StoredProcedureEvents = class end
public class StoredProcedureEvents
The StoredProcedureEvents type exposes the following members.
Methods
| Name | Description | |
|---|---|---|
.gif "Public method") |
Equals | (Inherited from Object.) |
.gif "Protected method") |
Finalize | (Inherited from Object.) |
|
GetEventSelection | Returns the currently selected event notifications. |
|
GetHashCode | (Inherited from Object.) |
|
GetType | (Inherited from Object.) |
|
MemberwiseClone | (Inherited from Object.) |
|
StartEvents | Starts receiving events. |
|
StopEvents | Stops receiving events. |
|
SubscribeToEvents(StoredProcedureEventSet) | Specifies the stored procedure events to receive. |
|
SubscribeToEvents(StoredProcedureEventSet, ServerEventHandler) | Specifies the stored procedure events to receive and the event handler that handles the events. |
|
ToString | (Inherited from Object.) |
|
UnsubscribeAllEvents | Clears all event settings, and removes all event handlers. |
|
UnsubscribeFromEvents | Clears the specified event settings, and removes all event handlers. |
Top
Events
| Name | Description | |
|---|---|---|
.gif "Public event") |
ServerEvent | Specifies the event raised when an event occurs in StoredProcedure object and the has user subscribed to the events from that object instance. |
Top
Remarks
The StoredProcedureEvents class is accessed through Events property and cannot be created as a stand-alone object.
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
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.