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
	UserDefinedFunctionEventSet()	Initializes a new instance of the UserDefinedFunctionEventSet class.
	UserDefinedFunctionEventSet(UserDefinedFunctionEvent)	Initializes a new instance of the UserDefinedFunctionEventSet class with a specified event.
	UserDefinedFunctionEventSet(array<UserDefinedFunctionEvent[])	Initializes a new instance of the UserDefinedFunctionEventSet class with a specified set of events.
	UserDefinedFunctionEventSet(UserDefinedFunctionEventSet)	Initializes a new instance of the UserDefinedFunctionEventSet class with a specified set of events.

Top

Properties

	Name	Description
	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.
	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.
	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.)
	Storage	Gets or sets the bit array for event set storage. (Inherited from EventSetBase.)

Top

Methods

	Name	Description
	Add(UserDefinedFunctionEvent)	Adds a UserDefinedFunctionEvent object to the UserDefinedFunctionEventSet object.
	Add(UserDefinedFunctionEventSet, UserDefinedFunctionEvent)	Adds a user defined function event to an user defined function event set.
	Copy	Returns a copy of the event set. (Overrides EventSetBase.Copy().)
	Equals	(Inherited from Object.)
	Finalize	(Inherited from Object.)
	FitsMask	Specifies whether the EventSetBase object fits the specified mask. (Inherited from EventSetBase.)
	GetHashCode	(Inherited from Object.)
	GetType	(Inherited from Object.)
	HasCommonBits	Specifies whether the EventSetBase object has common bits with another specified EventSetBase object. (Inherited from EventSetBase.)
	MemberwiseClone	(Inherited from Object.)
	Remove	Removes an event from the event set.
	SetValue	Sets the bit value at the specified index position. (Inherited from EventSetBase.)
	Subtract	Subtracts a user defined function event from a user defined function event set.
	ToString	Returns a String that represents the UserDefinedFunctionEventSet object. (Overrides Object.ToString().)

Top

Operators

	Name	Description
	Addition	Creates a user-defined function event set by performing an addition operation on a UserDefinedFunctionEvent object and a UserDefinedFunctionEventSet object.
	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