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
Public method Equals (Inherited from Object.)
Protected method Finalize (Inherited from Object.)
Public method GetEventSelection Returns the currently selected event notifications.
Public method GetHashCode (Inherited from Object.)
Public method GetType (Inherited from Object.)
Protected method MemberwiseClone (Inherited from Object.)
Public method StartEvents Starts receiving events.
Public method StopEvents Stops receiving events.
Public method SubscribeToEvents(StoredProcedureEventSet) Specifies the stored procedure events to receive.
Public method SubscribeToEvents(StoredProcedureEventSet, ServerEventHandler) Specifies the stored procedure events to receive and the event handler that handles the events.
Public method ToString (Inherited from Object.)
Public method UnsubscribeAllEvents Clears all event settings, and removes all event handlers.
Public method UnsubscribeFromEvents Clears the specified event settings, and removes all event handlers.

Top

Events

  Name Description
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

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