UserDefinedFunctionEventSet Class

The UserDefinedFunctionEventSet object represents a SQL Server set of user-defined function events.

Inheritance Hierarchy

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

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

Syntax

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

The UserDefinedFunctionEventSet type exposes the following members.

Constructors

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

Top

Properties

  Name Description
Public property AlterFunction Gets or sets a Boolean property value that specifies whether the event that occurs when a function is altered is included in the event set.
Public property DropFunction Gets or sets a Boolean property value that specifies whether the event that occurs when a function is dropped is included in the event set.
Public property NumberOfElements Gets or sets a Boolean property value that specifies whether the event that occurs when the number of elements changes is included 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(UserDefinedFunctionEvent) Adds a UserDefinedFunctionEvent object to the UserDefinedFunctionEventSet object.
Public methodStatic member Add(UserDefinedFunctionEventSet, UserDefinedFunctionEvent) Adds a user defined function event to an user defined function 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 Subtracts a user defined function event from a user defined function event set.
Public method ToString Returns a String that represents the UserDefinedFunctionEventSet object. (Overrides Object.ToString().)

Top

Operators

  Name Description
Public operatorStatic member Addition Creates a user-defined function event set by performing an addition operation on a UserDefinedFunctionEvent object and a UserDefinedFunctionEventSet object.
Public operatorStatic member Subtraction Creates a user-defined function event set by performing a subtraction operation on a UserDefinedFunctionEvent object and a UserDefinedFunctionEventSet object.

Top

Remarks

SQL Server provides events subscription for all SMO objects that have server event support. The UserDefinedFunction object has event support for the events represented by UserDefinedFunctionEventSet 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