Hi,
Relative Newbie, and considering using Service Broker and CLR Stored Procedures to monitor a table in a different database.
We are using SQL Server 2005.
I am expecting I can use an Event Monitor which will then send a message to a queue.
The goal is to extract data from the table being monitored and using a subset to update a table in the database which is doing monitoring.
Is this possible, am I on the right track?
I was looking at Notification Services, but have read that this is discontinued in SQL Server 2008.
Cheers
Wee!