Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

StoredProcedureEvents Class

The StoredProcedureEvents object represents the settings that are required for SQL Server stored procedure event notification.

System.Object
  Microsoft.SqlServer.Management.Smo.StoredProcedureEvents

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
type StoredProcedureEvents =  class end

The StoredProcedureEvents type exposes the following members.

  NameDescription
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Public methodGetEventSelectionReturns the currently selected event notifications.
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodStartEventsStarts receiving events.
Public methodStopEventsStops receiving events.
Public methodSubscribeToEvents(StoredProcedureEventSet)Specifies the stored procedure events to receive.
Public methodSubscribeToEvents(StoredProcedureEventSet, ServerEventHandler)Specifies the stored procedure events to receive and the event handler that handles the events.
Public methodToString (Inherited from Object.)
Public methodUnsubscribeAllEventsClears all event settings, and removes all event handlers.
Public methodUnsubscribeFromEventsClears the specified event settings, and removes all event handlers.
Top
  NameDescription
Public eventServerEventSpecifies the event raised when an event occurs in StoredProcedure object and the has user subscribed to the events from that object instance.
Top

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.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.