October 3, 2013 | Posted in: SQL Server
select [service].name, [queue].name
from sys.services [service]
join sys.service_queue_usages [useage]
on [service].service_id = [useage].service_id
join sys.service_queues [queue]
on [queue].object_id = [useage].service_queue_id
where [queue].is_ms_shipped = 0
Be the first to comment.