A good article and monitoring script from Johan Bijnens (ALZDBA) at SQLServerCentral.com:The Article: Adventures with Service BrokerAnd the monitoring script with just selects from every Service Broker DMV and catalog view: http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31867/
A good article and monitoring script from Johan Bijnens (ALZDBA) at SQLServerCentral.com:
The Article: Adventures with Service Broker
And the monitoring script with just selects from every Service Broker DMV and catalog view: http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31867/
Philly.net 2008.3 Code Camp is today, and I am delivering the above presentation. So I am attaching the promised materials, including my scripts and slides. Here it is: dnn/Portals/4/Materials.zip
An interesting article from 2006 on SQLServerCentral.com that details how to setup an "Asynchronus" Logon trigger, using a Logon Event Notification (and Service Broker):http://www.sqlservercentral.com/articles/SQLServerCentral.com/sqlserver2005logontriggers/2366/Like most Service Broker/Event Notifications articles, it appears that there may be some mistakes and/or omissions (Master Key?).
An interesting article from 2006 on SQLServerCentral.com that details how to setup an "Asynchronus" Logon trigger, using a Logon Event Notification (and Service Broker):
http://www.sqlservercentral.com/articles/SQLServerCentral.com/sqlserver2005logontriggers/2366/
Like most Service Broker/Event Notifications articles, it appears that there may be some mistakes and/or omissions (Master Key?).