I would like to enable_broker on a production database. It seems to be working fine in testing. I am wondering if there is any extra overhead is running the service broker on a busy production database or if it is preferable to create a new database?
We've been using Service Broker for some time now, and have been very happy with it, but yesterday we came across an issue that has us stumped. In testing an upcoming application, we preloaded 700K messages on a TargetQueue, then processed the data, but to try and get better ...
I'm implementing a transactional receive from SSB queue. I used System.Transactions.TransactionScope to simplify the transaction management code. When I used the "WAITFOR (RECEIVE ...), TIMEOUT 100" statment I get TransactionAbortedException when I try to open