Good day. There is a database whose Service broker has several queues that are not in the System Queues folder (dbo.queue / front, dbo.queue / process and dbo.queue / transmit).

Queues

The task was set - a SQL query to check these queues for neglect. Found the following command:

SELECT is_receive_enabled FROM sys.service_queues

but this command displays the status of only three queues from the "System Queues" folder, the status of the queues I need is not displayed. Tell me, please, request, which can check the status of these queues.

  • one
    Your request should give you back all the queues. If any queues are not returned, then the user who executes this request probably does not have enough rights to the corresponding queue object. - i-one
  • @ i-one where rights to queues are assigned? - zigr0lf
  • one
    Object rights can be inherited through membership in roles ( ALTER ROLE ... ADD MEMBER ... ), or issued / withdrawn directly ( GRANT / DENY instructions). In SSMS, this is done in the database Security menu. - i-one
  • You can view the rights to an object with the query: select * from sys.fn_my_permissions('dbo.queue/front', 'OBJECT') . - i-one

0