Scripts to enable SQL Service Broker
Just recently a newcomer in our team could not get his windows service to work properly, and get messages from sql service broker queue. In the end it turned out that in the main database that was created from scratch, service broker appeared to be disabled. Here are some scripts to enable it:
alter database [mydatabase] set single_user with rollback immediate
alter database [mydatabase] set enable_broker
alter database [mydatabase] set multi_user with no_wait
Мітки: sql 2008, sql service broker
0 коментарі(в):
Дописати коментар
Підписка на Дописати коментарі [Atom]
<< Головна сторінка