dotnet web sql business etc

26 серпня, 2011

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

Мітки: ,

0 коментарі(в):

Дописати коментар

Підписка на Дописати коментарі [Atom]

<< Головна сторінка