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.

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.