sql-server - 在队列名称后查询 MSSQL？

Question

我可以执行某种查询以使用服务名称检索队列名称吗？

Answer 1

sys.services :

service_queue_id Object id for the queue that this service uses. Not NULLABLE.

因此，大致如下:

SELECT name as service_name, 
   OBJECT_SCHEMA_NAME(service_queue_id) as queue_schema_name,
   OBJECT_NAME(service_queue_id) as queue_name 
FROM sys.services