How do I enable a disabled Event Notification.
- by Derick Mayberry
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.