مشاركة عبر


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
Public propertyStatic member AlterProcedure Gets a stored procedure event that can be included in the event set.
Public propertyStatic member DropProcedure Gets a stored procedure event that can be included in the event set.

Top

Methods

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

Top

Operators

  Name Description
Public operatorStatic member Addition Creates a stored procedure event set by performing an addition operation on two StoredProcedureEvent objects.
Public operatorStatic member BitwiseOr Creates a stored procedure event set by performing a bitwise OR operation on two StoredProcedureEvent objects.
Public operatorStatic member Equality Creates a stored procedure event set by performing an equality operation on two StoredProcedureEvent objects.
Public operatorStatic member Implicit(StoredProcedureEvent to StoredProcedureEventSet) Casts a single Stored Procedure Event as a Stored Procedure Event Set.
Public operatorStatic member 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