Table of Contents

Class ObjectSchema.ServerSqlModule

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

sys.server_sql_modules (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Contains the set of SQL modules for server-level triggers of type TR. You can join this relation to sys.server_triggers. The tuple (object_id) is the key of the relation.


See sys.server_sql_modules.

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

Properties

Definition

SQL text that defines this module.

NULL = Encrypted.

[Column("definition")]
[Nullable]
public string? Definition { get; set; }

Property Value

string

ExecuteAsPrincipalID

ID of the EXECUTE AS server principal.

NULL by default or if EXECUTE AS CALLER

ID of the specified principal if EXECUTE AS SELF EXECUTE AS principal-2 = EXECUTE AS OWNER.

[Column("execute_as_principal_id")]
[Nullable]
public int? ExecuteAsPrincipalID { get; set; }

Property Value

int?

Object

objects (sys.objects)

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

Property Value

ObjectSchema.Object

ObjectID

This is a FOREIGN KEY reference back to the server-level trigger where this module is defined.

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

Property Value

int

UsesAnsiNulls

Module was created with ANSI NULLS set option set to ON.

[Column("uses_ansi_nulls")]
[Nullable]
public bool? UsesAnsiNulls { get; set; }

Property Value

bool?

UsesQuotedIdentifier

Module was created with QUOTED IDENTIFIER set option set to ON.

[Column("uses_quoted_identifier")]
[Nullable]
public bool? UsesQuotedIdentifier { get; set; }

Property Value

bool?