SqlAssemblyEventSet Class

The SqlAssemblyEventSet object represents a set of assembly events.

Inheritance Hierarchy

System.Object
  Microsoft.SqlServer.Management.Smo.EventSetBase
    Microsoft.SqlServer.Management.Smo.SqlAssemblyEventSet

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

Syntax

'Declaration
Public NotInheritable Class SqlAssemblyEventSet _
    Inherits EventSetBase
'Usage
Dim instance As SqlAssemblyEventSet
public sealed class SqlAssemblyEventSet : EventSetBase
public ref class SqlAssemblyEventSet sealed : public EventSetBase
[<SealedAttribute>]
type SqlAssemblyEventSet =  
    class 
        inherit EventSetBase 
    end
public final class SqlAssemblyEventSet extends EventSetBase

The SqlAssemblyEventSet type exposes the following members.

Constructors

  Name Description
Public method SqlAssemblyEventSet() Initializes a new instance of the SqlAssemblyEventSet class.
Public method SqlAssemblyEventSet(SqlAssemblyEvent) Initializes a new instance of the SqlAssemblyEventSet class with a specified event.
Public method SqlAssemblyEventSet(array<SqlAssemblyEvent[]) Initializes a new instance of the SqlAssemblyEventSet class with a specified set of events.
Public method SqlAssemblyEventSet(SqlAssemblyEventSet) Initializes a new instance of the SqlAssemblyEventSet class with a specified set of events.

Top

Properties

  Name Description
Public property AlterAssembly Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an assembly is altered.
Public property DropAssembly Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an assembly is dropped.
Public property NumberOfElements Gets the number of elements in the event set. (Overrides EventSetBase.NumberOfElements.)
Protected property Storage Gets or sets the bit array for event set storage. (Inherited from EventSetBase.)

Top

Methods

  Name Description
Public method Add(SqlAssemblyEvent) Returns an SQL assembly event set after adding a new SQL assembly event to the referenced event set.
Public methodStatic member Add(SqlAssemblyEventSet, SqlAssemblyEvent) Returns an SQL assembly event set after adding a new SQL assembly event to the specified event set.
Public method Copy Returns a copy of the event set. (Overrides EventSetBase.Copy().)
Public method Equals (Inherited from Object.)
Public method GetHashCode (Inherited from Object.)
Public method GetType (Inherited from Object.)
Public method Remove Removes an event from the event set.
Public methodStatic member Subtract Returns an SQL assembly event set after subtracting a new SQL assembly event from the specified event set.
Public method ToString Returns a string that represents the SqlAssemblyEventSet object. (Overrides Object.ToString().)

Top

Operators

  Name Description
Public operatorStatic member Addition Creates an assembly event set by performing an addition operation on a SqlAssemblyEvent object and a SqlAssemblyEventSet object.
Public operatorStatic member Subtraction Creates an assembly event set by performing a subtraction operation on a SqlAssemblyEvent object and a SqlAssemblyEventSet object.

Top

Remarks

SQL Server provides events subscription for all SMO objects that have server event support. The SqlAssembly object has event support for the events represented by SqlAssemblyEventSet properties.

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