| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.service_queues (Transact-SQL) |
sys.service_queues (Transact-SQL) |
rwestMSFT |
randolphwest |
03/15/2017 |
sql |
system-objects |
reference |
|
|
|
[!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)