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