Enable Service Broker in db - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Enable Service Broker in db

Author

Topic

subhaoviya
Posting Yak Master

135 Posts

Posted - 2012-12-10 : 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.

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2012-12-10 : 06:51:02

try with this option: WITH NO_WAIT

http://social.msdn.microsoft.com/Forums/is/sqldatabaseengine/thread/fba5b7c2-2562-44cc-83ec-0789b05fdff3
http://www.mssqltips.com/sqlservertip/2789/sql-server-service-broker-error-database-cannot-be-enabled/

EDIT: Check this http://geekswithblogs.net/naijacoder/archive/2008/10/15/125879.aspx
Follow these links

--
Chandu

subhaoviya
Posting Yak Master

135 Posts

Posted - 2012-12-10 : 08:20:11

Hi all,
I got the solution for this, actually if the database is accessed by some one, then we cant enable the broker service.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources