My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Service Broker - Always check @@rowcount
The new RSS feed is here
If you're using service broker you will may be using activation to have a stored procedue read messages off a queue. If you are make sure you are aware that you activation procedure will be activated at times even when they're are no messages.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Service Broker - Always check @@rowcount