Loading ...

SET ENABLE BROKER in SQL Server 2005. | CodeAsp.Net

SET ENABLE BROKER in SQL Server 2005

 /5
0 (0votes)

SQL Server got hanged when we try the enable service broker. So to get rid of this you have to follow these steps:

  1. First of all kill all the connections.
  2. After that changed  DB mode into single user

ALTER DATABASE database_name
SET SINGLE_USER

3. Enable the broker

ALTER DATABASE database_name
SET ENABLE_BROKER

4. Finally set DB mode to multi user

ALTER DATABASE database_name
SET MULTI_USER

 

Hope this help you

Comments (2)

   
nguyen ngoc
when I run  statement :

ALTER DATABASE database_name
SET ENABLE_BROKER
go

error:
Incorrect syntax near 'ENABLE_BROKER'.

how?
8/20/2009
 · 
by
   
vinay_jss
ALTER DATABASE Your_Database_Name SET ENABLE_BROKER.
You have to change the database_name with your database name, where you want to enable broker.
8/21/2009
 · 
by

Top Posts