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
	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.

Top

Events

	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.

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