Saturday, February 25, 2012

Delete sys.Transmission_Queue

I have seen this buried deep with the questions on Service Broker, but I am looking for it again. How do you delete all records from your sys.Transmission_Queue. This is on a test server and I want to clean it before some more test.

alter database foo set new_broker;

No comments:

Post a Comment