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.
| 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. |
| is_poison_message_handling_enabled | bit | Applies to: SQL Server 2012 (11.x) and later. 1 = Poison message handling is enabled. |
Permissions
The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata Visibility Configuration.
See Also
Object Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)