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.

Leave a Reply

*


14 − four =


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>