I have been using Service Broker recently and found it exciting and useful. It seems like a cool feather in SQL Server. I use the SQL Dependency class in my .Net Windows Service to listen for the Service Broker Notification. When there is an Insert to the tables in my database the Service Broker sends me a Notification which alerts my Windows Service Application to Query data from the table and do the processing. It works very well.
