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: 370
        
service
|sql-server-service-broker
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