StoredProcedureEvent Class

The StoredProcedureEvent object represents the SQL Server stored procedure events that can be included in an stored procedure event set.

Inheritance Hierarchy

System.Object
  Microsoft.SqlServer.Management.Smo.StoredProcedureEvent

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public NotInheritable Class StoredProcedureEvent
'Usage
Dim instance As StoredProcedureEvent

public sealed class StoredProcedureEvent

public ref class StoredProcedureEvent sealed

[<SealedAttribute>]
type StoredProcedureEvent =  class end

public final class StoredProcedureEvent

The StoredProcedureEvent type exposes the following members.

Properties

	Name	Description
	AlterProcedure	Gets a stored procedure event that can be included in the event set.
	DropProcedure	Gets a stored procedure event that can be included in the event set.

Top

Methods

	Name	Description
	Add	Returns the stored procedure event set that is created when two stored procedure events are added together.
	BitwiseOr	Creates a Stored Procedure Event Set by combining two Stored Procedure Events by using a Bitwise OR.
	Equals	Determines whether the referenced stored procedure event object is equal to the specified object. (Overrides Object.Equals(Object).)
	GetHashCode	This method supports the SQL Server infrastructure and is not intended to be used directly from your code. (Overrides Object.GetHashCode().)
	GetType	(Inherited from Object.)
	ToString	Returns the referenced object in string format. (Overrides Object.ToString().)

Top

Operators

	Name	Description
	Addition	Creates a stored procedure event set by performing an addition operation on two StoredProcedureEvent objects.
	BitwiseOr	Creates a stored procedure event set by performing a bitwise OR operation on two StoredProcedureEvent objects.
	Equality	Creates a stored procedure event set by performing an equality operation on two StoredProcedureEvent objects.
	Implicit(StoredProcedureEvent to StoredProcedureEventSet)	Casts a single Stored Procedure Event as a Stored Procedure Event Set.
	Inequality	Creates a stored procedure event set by performing an inequality operation on two StoredProcedureEvent objects.

Top

Remarks

The StoredProcedureEvent object contains a property for each event to which stored procedure can respond. The actual set of events is specified using the StoredProcedureEventSet 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