.png)
sys.service_queues (Transact-SQL)
Contains a row for each object in the database that is a service queue, with sys.objects.type = SQ.
| Column name | Data type | Description |
|---|---|---|
|
<inherited columns> |
For a list of columns that this view inherits, see sys.objects (Transact-SQL). | |
|
max_readers |
smallint |
Maximum number of the concurrent readers allowed in the queue. |
|
activation_procedure |
nvarchar(776) |
Three-part name of the activation procedure. |
|
execute_as_principal_id |
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. |
|
is_activation_enabled |
bit |
1 = Activation is enabled. |
|
is_receive_enabled |
bit |
1 = Receive is enabled. |
|
is_enqueue_enabled |
bit |
1 = Enqueue is enabled. |
|
is_retention_enabled |
bit |
1 = Messages are retained until dialog end. |
Reference
Object Catalog Views (Transact-SQL)Catalog Views (Transact-SQL)
