Queue Properties (General Page)

Options

• 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.

See Also

Reference

Concepts