What Was I Thinking?

Follies & Foils of .NET Development
posts - 85 , comments - 251 , trackbacks - 0

January 2013 Entries

A consolidated View of Broker Service Queues

USE [CatalogWithMessageBroker]

GO

select q.name as QueueName, p.rows as MsgCount, case sq.is_receive_enabled when 0 then 'Disabled' else 'Enabled' end as QueueEnabled
from sys.objects as o
join sys.partitions as p on p.object_id = o.object_id
join sys.objects as q on o.parent_object_id = q.object_id
join sys.service_queues sq on sq.name = q.name
where p.index_id = 1

Posted On Tuesday, January 22, 2013 9:14 AM | Comments (0) |

Powered by: