Export (0) Print
Expand All

Queue Properties (General Page)

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.

Name

The name of the queue. The name must be unique within the database.

ID

An integer that identifies the queue in the database.

Create date

Date when the queue was created.

Last modified date

Date when the queue was last altered.

File group

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:

ON

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.

OFF

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:

ON

Specifies that Service Broker can place new messages in the queue.

OFF

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:

ON

Specifies that messages are retained in the queue until the conversation they are part of ends.

OFF

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:

SELF

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.

OWNER

The activation stored procedure runs in the context of the database principal that owns the stored procedure.

'user_name'

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.

Maximum readers

The maximum number of copies of the activation stored procedure that can be run.

Procedure database

The name of the database that contains the activation stored procedure.

Procedure name

The name of the activation stored procedure.

Procedure schema

The name of the schema that contains the activation stored procedure.

Message count

The number of messages in the queue.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft