This documentation is archived and is not being maintained.
Queue Properties (General Page)
SQL Server 2008 R2
Displays the properties of the selected Service Broker queue. Queues receive messages sent from Service Broker services. This page is accessed by right-clicking an existing queue in Object Explorer and clicking Properties.
The name of the queue. The name must be unique within the database.
An integer that identifies the queue in the database.
Date when the queue was created.
Last modified date
Date when the queue was last altered.
The file group on which the queue was created.
Is activation enabled
Specifies whether an activation stored procedure is run to receive messages from the queue:
Specifies that Service Broker starts a copy of the activation stored procedure when there are messages in the queue. The Procedure name property lists the name of the activation stored procedure.
Specifies that Service Broker does not start an activation stored procedure, even if an activation stored has been defined for the queue. Messages must be retrieved from the queue using some code that runs the RECEIVE statement. You can enable activation by running ALTER QUEUE with an ACTIVATION clause that specifies STATUS = ON, and ensure the queue has an activation stored procedure.
Is enqueue enabled
Specifies whether new messages can be placed in the queue:
Specifies that Service Broker can place new messages in the queue.
Specifies that no new messages can be placed in the queue until ALTER QUEUE is run with STATUS = ON specified.
Is retention enabled
Specifies when messages are deleted from the queue:
Specifies that messages are retained in the queue until the conversation they are part of ends.
Specifies that messages are deleted from the queue when the RECEIVE statement that retrieves them is committed.
Activation execution context
Specifies the execution context defined for the activation stored procedure:
The activation stored procedure runs in the context of the database principal that executed the CREATE QUEUE or ALTER QUEUE statement that specified the execution context.
The activation stored procedure runs in the context of the database principal that owns the stored procedure.
The activation stored procedure runs in the context of the specified database principal.
Execution context principal
The database principal under which the activation stored procedure runs. This is the database principal that the value specified for activation execution context resolved to.
The maximum number of copies of the activation stored procedure that can be run.
The name of the database that contains the activation stored procedure.
The name of the activation stored procedure.
The name of the schema that contains the activation stored procedure.