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_poison_message_handling_enabled |
bit |
1 = poison message handling is enabled in the queue. |
is_retention_enabled |
bit |
1 = Messages are retained until dialog end. |
Permissions
In SQL Server 2005 and later versions, the visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.