Table of Contents

Class ObjectSchema.ServerEventNotification

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.server_event_notifications (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Returns a row for each server-level event notification object.


See sys.server_event_notifications.

[Table(Schema = "sys", Name = "server_event_notifications", IsView = true)]
public class ObjectSchema.ServerEventNotification
Inheritance
ObjectSchema.ServerEventNotification
Extension Methods

Properties

BrokerInstance

The service broker where the named target service is defined.

[Column("broker_instance")]
[Nullable]
public string? BrokerInstance { get; set; }

Property Value

string

CreateDate

Date created.

[Column("create_date")]
[NotNull]
public DateTime CreateDate { get; set; }

Property Value

DateTime

CreatorSID

SID of the login executing the statement that creates the event notification. NULL if WITH FAN_IN is not specified in the event notification definition.

[Column("creator_sid")]
[Nullable]
public byte[]? CreatorSID { get; set; }

Property Value

byte[]

ModifyDate

Date object was last modified by using an ALTER statement.

[Column("modify_date")]
[NotNull]
public DateTime ModifyDate { get; set; }

Property Value

DateTime

Name

Server event notification name. Is unique across all server-level event notifications.

[Column("name")]
[NotNull]
public string Name { get; set; }

Property Value

string

Object

objects (sys.objects)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = false)]
public ObjectSchema.Object Object { get; set; }

Property Value

ObjectSchema.Object

ObjectID

Object identification number. Is unique within the master database.

[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }

Property Value

int

ParentClass

Class of parent. Is always 100 = Server.

[Column("parent_class")]
[NotNull]
public byte ParentClass { get; set; }

Property Value

byte

ParentClassDesc

Description of class of parent. Is always SERVER.

[Column("parent_class_desc")]
[Nullable]
public string? ParentClassDesc { get; set; }

Property Value

string

ParentID

Is always 0.

[Column("parent_id")]
[NotNull]
public int ParentID { get; set; }

Property Value

int

PrincipalID

ID of the server principal that owns this.

[Column("principal_id")]
[Nullable]
public int? PrincipalID { get; set; }

Property Value

int?

ServiceName

Name of the target service to which the notification is sent.

[Column("service_name")]
[Nullable]
public string? ServiceName { get; set; }

Property Value

string