SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Enable Service Broker in db
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

subhaoviya
Posting Yak Master

India
135 Posts

Posted - 12/10/2012 :  04:42:43  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

India
2217 Posts

Posted - 12/10/2012 :  06:51:02  Show Profile  Reply with Quote
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

Edited by - bandi on 12/10/2012 07:10:55
Go to Top of Page

subhaoviya
Posting Yak Master

India
135 Posts

Posted - 12/10/2012 :  08:20:11  Show Profile  Reply with Quote
Hi all,
I got the solution for this, actually if the database is accessed by some one, then we cant enable the broker service.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000