how long lasts ALTER DATABASE [msdb] SET ENABLE

how long lasts ALTER DATABASE [msdb] SET ENABLE_BROKER ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Scan le Gentil - 24 Apr 2006 11:45 GMT

My command never ends :

ALTER DATABASE [msdb] SET ENABLE_BROKER ;

Any idea ?

(it works on user DBs and I have one endpoint created yet)

Thanks for any helps

Scan le Gentil

Reply to this Message

Tibor Karaszi - 24 Apr 2006 13:41 GMT

Make sure no-one is using the database (lick out all users). This includes SQL Server Agent.

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

> My command never ends :
>
[quoted text clipped - 7 lines]
>
> Scan le Gentil

Reply to this Message

Chris Leiter - 24 Apr 2006 15:40 GMT

That includes yourself. Make sure you don't have another connection open to
the same database. That's bitten me a couple of times.

-Chris

> Make sure no-one is using the database (lick out all users). This includes
> SQL Server Agent.
[quoted text clipped - 10 lines]
>>
>> Scan le Gentil

Reply to this Message

Roger Wolter[MSFT] - 24 Apr 2006 15:53 GMT

http://blogs.msdn.com/remusrusanu/archive/2006/01/30/519685.aspx

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

> That includes yourself. Make sure you don't have another connection open
> to the same database. That's bitten me a couple of times.
[quoted text clipped - 15 lines]
>>>
>>> Scan le Gentil

Reply to this Message

manishkaushik - 08 Jan 2009 09:21 GMT

Try this this, worked for me

ALTER DATABASE [msdb] SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE

thanks
Manish

Reply to this Message