• Product Information
  • About
  • Product tour
  • News
  • Screenshots
  • Testimonials
• Support Information
  • Documentation
  • FAQ
  • Support
• Download
• Purchase

MS SQL Maestro online Help

Specifying new queue properties

Specify new Queue properties according to your needs. The detailed description is given below.

Name

Enter the name of the queue to create. This name must meet the guidelines for SQL Server identifiers.

Owner

Defines the owner of the queue.

Status

Specifies whether the queue is available (checked) or unavailable (unchecked). When the queue is unavailable, no messages can be added to the queue or removed from the queue. You can create the queue in an unavailable state in order to keep messages from arriving on the queue until the queue is made available within Queue Editor.

Retention

Specifies the retention setting for the queue. If checked, all messages sent or received on conversations using this queue are retained in the queue until the conversations have ended. This allows you to retain messages for auditing purposes, or to perform compensating transactions if an error occurs.

Activation options (Procedure name, Status, Max readers, Execute As)

Specifies information about the stored procedure to activate to process messages in this queue:

Procedure name

Specifies the name of the stored procedure to activate to process messages in this queue. This value must be a SQL Server identifier.

Status

Specifies whether or not Service Broker activates the stored procedure. When checked, the queue starts the stored procedure specified with Procedure name when the number of procedures currently running is less than Max readers and when messages arrive on the queue faster than the stored procedures receive messages. When unchecked, the queue does not activate the stored procedure.

Max readers

Specifies the maximum number of instances of the activation stored procedure that the queue starts at the same time. The value of readers must be a number between 0 and 32767.

Execute As

Specifies the SQL Server database user account under which the activation stored procedure runs. SQL Server must be able to check the permissions for this user at the time that the queue activates the stored procedure. For an NT domain user, the server must be connected to the domain when the procedure is activated or activation fails. For a SQL Server user, the server can always check permissions.