| title | sys.service_queues (Transact-SQL) | ||||
|---|---|---|---|---|---|
| description | sys.service_queues (Transact-SQL) | ||||
| author | rwestMSFT | ||||
| ms.author | randolphwest | ||||
| ms.date | 03/15/2017 | ||||
| ms.service | sql | ||||
| ms.subservice | system-objects | ||||
| ms.topic | reference | ||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
[!INCLUDE 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: [!INCLUDEssSQL11] and later. 1 = Poison message handling is enabled. |
[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.
Object Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)