How do I enable a disabled Event Notification.

Posted by Derick Mayberry on Server Fault See other posts from Server Fault or by Derick Mayberry
Published on 2010-02-09T17:21:19Z Indexed on 2010/05/01 4:08 UTC
Read the original article Hit count: 291

I have a scenerio where I am using external notification to process documents being sent in from the entire navy fleet, normally I have no problems, but just a few days ago an administrator changed passwords and I my queue processing failed and I rolled back the transaction with this C# code:

catch (Exception) { TransporterService.WriteEventToWindowsLog(AppName, "Rolling Back Transaction:", ERROR); broker.Tran.Rollback(); break; }

after which my target queue would continue to fill up but nothing to the external activation queue. Does the Event Notification get disabled once a transaction is rolled back? Should I have done a broker.EndDialog here when catching my exception?

Also, after my event notification is disabled(if that is actually whats happening) how do I re engage it? Do I have to drop it and recreate it? Thank in advance for any help, I love Service Broker and its workign wonderfully except for this bug that I hope to fix soon.

© Server Fault or respective owner

Related posts about service

Related posts about sql-server-service-broker