I recently setup Service Broker - Internal Activation. I ran built-in SSMS "Service Broker Statistics" reports and saw this;
Store Procedures Invoked/sec : 184
Tasks Aborted/sec :184
Tasks Running: 0
Tasks Started/sec: 184
I used "SET XACT_ABORT ON" at the top of the activation sproc. Do you think all transactions through the activation sproc are rolling back?
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?