2

I have a database where I have a ServiceBroker up and running. For unknown reasons we have experienced a lot of problems with missing conversation handlers;

I.e.

The conversation handle "D33EC01C-CEA9-E811-95C5-00155D009F03" is not found.

It is my belief that this has happened when DB has been restarted while conversations have been "open" if that makes any sense.

What I wish to do now is to "reset" the ServiceBroker, remove all conversations, messages, triggers(!) etc.

Unfortunately I haven´t seen any documentation on how to achieve this.

Ideas?

Marcus
  • 225
  • 1
  • 3
  • 8

1 Answers1

-1

Its cause due to multi-trigger on the table which created by service broker.

enter image description here

Delete all trigger and start broker services or then try.

virender
  • 99