Table of Contents

Class ServiceBrokerSchema.ServiceQueue

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

sys.service_queues (Transact-SQL)

Applies to: √ SQL Server

Contains a row for each object in the database that is a service queue, with sys.objects.type = SQ.


See sys.service_queues.

[Table(Schema = "sys", Name = "service_queues", IsView = true)]
public class ServiceBrokerSchema.ServiceQueue
Inheritance
ServiceBrokerSchema.ServiceQueue
Inherited Members
Extension Methods

Properties

ActivationProcedure

activation_procedure NULL nvarchar(776)

Three-part name of the activation procedure. 
[Column("activation_procedure")]
[Nullable]
public string? ActivationProcedure { get; set; }

Property Value

string

CreateDate

create_date NOT NULL datetime

Date the object was created. 
[Column("create_date")]
[NotNull]
public DateTime CreateDate { get; set; }

Property Value

DateTime

ExecuteAsPrincipalID

execute_as_principal_id NULL int

ID of the EXECUTE AS database 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?

IsActivationEnabled

is_activation_enabled NOT NULL bit

1 = Activation is enabled. 
[Column("is_activation_enabled")]
[NotNull]
public bool IsActivationEnabled { get; set; }

Property Value

bool

IsEnqueueEnabled

is_enqueue_enabled NOT NULL bit

1 = Enqueue is enabled. 
[Column("is_enqueue_enabled")]
[NotNull]
public bool IsEnqueueEnabled { get; set; }

Property Value

bool

IsMSShipped

is_ms_shipped NOT NULL bit

Object is created by an internal SQL Server component. 
[Column("is_ms_shipped")]
[NotNull]
public bool IsMSShipped { get; set; }

Property Value

bool

IsPoisonMessageHandlingEnabled

is_poison_message_handling_enabled NULL bit

Applies to: SQL Server 2012 (11.x) and later.

1 = Poison message handling is enabled. 
[Column("is_poison_message_handling_enabled")]
[Nullable]
public bool? IsPoisonMessageHandlingEnabled { get; set; }

Property Value

bool?

IsPublished

is_published NOT NULL bit

Object is published. 
[Column("is_published")]
[NotNull]
public bool IsPublished { get; set; }

Property Value

bool

IsReceiveEnabled

is_receive_enabled NOT NULL bit

1 = Receive is enabled. 
[Column("is_receive_enabled")]
[NotNull]
public bool IsReceiveEnabled { get; set; }

Property Value

bool

IsRetentionEnabled

is_retention_enabled NOT NULL bit

1 = Messages are retained until dialog end. 
[Column("is_retention_enabled")]
[NotNull]
public bool IsRetentionEnabled { get; set; }

Property Value

bool

IsSchemaPublished

is_schema_published NOT NULL bit

Only the schema of the object is published. 
[Column("is_schema_published")]
[NotNull]
public bool IsSchemaPublished { get; set; }

Property Value

bool

MaxReaders

max_readers NULL smallint

Maximum number of the concurrent readers allowed in the queue. 
[Column("max_readers")]
[Nullable]
public short? MaxReaders { get; set; }

Property Value

short?

ModifyDate

modify_date NOT NULL datetime

Date the object was last modified by using an ALTER statement. If the object is a table or a view, modify_date also changes when an index on the table or view is created or altered. 
[Column("modify_date")]
[NotNull]
public DateTime ModifyDate { get; set; }

Property Value

DateTime

Name

name NOT NULL sysname

Object name. 
[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_id NOT NULL int

Object identification number. Is unique within a database. 
[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }

Property Value

int

ParentObjectID

parent_object_id NOT NULL int

ID of the object to which this object belongs.

0 = Not a child object. 
[Column("parent_object_id")]
[NotNull]
public int ParentObjectID { get; set; }

Property Value

int

PrincipalID

principal_id NULL int

ID of the individual owner, if different from the schema owner. By default, schema-contained objects are owned by the schema owner. However, an alternate owner can be specified by using the ALTER AUTHORIZATION statement to change ownership.

NULL if there's no alternate individual owner.

Is NULL if the object type is one of the following values:

C = Check constraint
D = Default (constraint or stand-alone)
F = Foreign key constraint
PK = Primary key constraint
R = Rule (old-style, stand-alone)
TA = Assembly (CLR-integration) trigger
TR = SQL trigger
UQ = Unique constraint
EC = Edge constraint 
[Column("principal_id")]
[Nullable]
public int? PrincipalID { get; set; }

Property Value

int?

SchemaID

schema_id NOT NULL int

ID of the schema that the object is contained in.

Schema-scoped system objects are always contained in the sys or INFORMATION_SCHEMA schemas. 
[Column("schema_id")]
[NotNull]
public int SchemaID { get; set; }

Property Value

int

Type

type NULL char(2)

Object type:

AF = Aggregate function (CLR)
C = Check constraint
D = Default (constraint or stand-alone)
F = Foreign key constraint
FN = SQL scalar function
FS = Assembly (CLR) scalar-function
FT = Assembly (CLR) table-valued function
IF = SQL inline table-valued function (TVF)
IT = Internal table
P = SQL stored procedure
PC = Assembly (CLR) stored-procedure
PG = Plan guide
PK = Primary key constraint
R = Rule (old-style, stand-alone)
RF = Replication-filter-procedure
S = System base table
SN = Synonym
SO = Sequence object
U = Table (user-defined)
V = View

Applies to: SQL Server 2012 (11.x) and later versions

SQ = Service queue
TA = Assembly (CLR) DML trigger
TF = SQL table-valued-function (TVF)
TR = SQL DML trigger
TT = Table type
UQ = unique constraint
X = Extended stored procedure

Applies to: SQL Server 2014 (12.x) and later versions, Azure SQL Database, Azure Synapse Analytics, Analytics Platform System (PDW)

ST = Statistics tree

Applies to: SQL Server 2016 (13.x) and later versions, Azure SQL Database, Azure Synapse Analytics, Analytics Platform System (PDW)

ET = External table

Applies to: SQL Server 2017 (14.x) and later versions, Azure SQL Database, Azure Synapse Analytics, Analytics Platform System (PDW)

EC = Edge constraint 
[Column("type")]
[Nullable]
public string? Type { get; set; }

Property Value

string

TypeDesc

type_desc NULL nvarchar(60)

Description of the object type:

AGGREGATE_FUNCTION
CHECK_CONSTRAINT
CLR_SCALAR_FUNCTION
CLR_STORED_PROCEDURE
CLR_TABLE_VALUED_FUNCTION
CLR_TRIGGER
DEFAULT_CONSTRAINT
EDGE_CONSTRAINT
EXTENDED_STORED_PROCEDURE
FOREIGN_KEY_CONSTRAINT
INTERNAL_TABLE
PLAN_GUIDE
PRIMARY_KEY_CONSTRAINT
REPLICATION_FILTER_PROCEDURE
RULE
SEQUENCE_OBJECT
SERVICE_QUEUE
SQL_INLINE_TABLE_VALUED_FUNCTION
SQL_SCALAR_FUNCTION
SQL_STORED_PROCEDURE
SQL_TABLE_VALUED_FUNCTION
SQL_TRIGGER
SYNONYM
SYSTEM_TABLE
TYPE_TABLE
UNIQUE_CONSTRAINT
USER_TABLE
VIEW 
[Column("type_desc")]
[Nullable]
public string? TypeDesc { get; set; }

Property Value

string