|
subhaoviya
Posting Yak Master
India
119 Posts |
 Posted - 12/10/2012 : 04:42:43
|
Hi,
In my database the service broker is not active, to find this i uesd the below metioned query.
SELECT is_broker_enabled FROM sys.databases WHERE name = 'msdb';
To enable the service broker while I run the query
USE master ;
GO
ALTER DATABASE DBName SET ENABLE_BROKER ;
GO
this query is keep on running with out end.
please provide suggestion to overcome this issue.
|
|
Enable Service Broker in db
