Showing posts with label view. Show all posts
Showing posts with label view. Show all posts

Tuesday, April 14, 2015

SQL Server view for monitoring open Service Broker conversations


SELECT conversation_handle
 ,is_initiator
 ,s.NAME AS 'local service'
 ,far_service
 ,sc.NAME 'contract'
 ,ce.state_desc
FROM sys.conversation_endpoints ce
LEFT JOIN sys.services s ON ce.service_id = s.service_id
LEFT JOIN sys.service_contracts sc ON ce.service_contract_id = sc.service_contract_id;