2012年2月24日星期五

Disabled Service Broker

I have a windows service that uses SqlDependency. It has been working fine until today where it has died. I have traced the problem back to the service broker being disabled, however I have not disabled the service broker. Is there anyway that the service broker can become disabled ?

Database restore and/or attach operations will leave the broker in the database disabled. You must manually enable it back after each restore operation.

没有评论:

发表评论