StoredProcedureEvents Class
SQL Server 2012
The StoredProcedureEvents object represents the settings that are required for SQL Server stored procedure event notification.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
The StoredProcedureEvents type exposes the following members.
| Name | Description | |
|---|---|---|
 | Equals | (Inherited from Object.) |
| 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. |
| Name | Description | |
|---|---|---|
| ServerEvent | Specifies the event raised when an event occurs in StoredProcedure object and the has user subscribed to the events from that object instance. |
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.
