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: 317
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