SET ENABLE_BROKER taking forever

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Yashgt - 13 May 2008 16:37 GMT

I am trying to run the service broker samples on teh AdventureWorks DB
on SQL Server Developer edition on Win XP, version 9.00.2050.00.

The statement ALTER DATABASE AdventureWorks SET ENABLE_BROKER ; takes
forever. Any clues as to what might be the cause?

Thanks,
Yash

Reply to this Message

Adam Machanic - 13 May 2008 18:46 GMT

Probably just need to kick other sessions out.

USE AdventureWorks
GO

ALTER DATABASE AdventureWorks SET SINGLE_USER WITH ROLLBACK IMMEDIATE
ALTER DATABASE AdventureWorks SET ENABLE_BROKER
ALTER DATABASE AdventureWorks SET MULTI_USER
GO

Signature

Adam Machanic
SQL Server MVP - http://sqlblog.com

Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220

>I am trying to run the service broker samples on teh AdventureWorks DB
> on SQL Server Developer edition on Win XP, version 9.00.2050.00.
[quoted text clipped - 4 lines]
> Thanks,
> Yash

Reply to this Message

Aaron Bertrand [SQL Server MVP] - 14 May 2008 04:13 GMT

You need exclusive access to the database in order to enable the broker.

Adam showed you the syntax to do so. I would schedule this for off-hours to
minimize the chance of interrupting normal activity (e.g. End users).

A

On 5/13/08 11:37 AM, in article
f5884f4c-9a97-41a9-8ed5-0142c501faac@a9g2000prl.googlegroups.com, "Yashgt"
<yashgt@gmail.com> wrote:

> I am trying to run the service broker samples on teh AdventureWorks DB
> on SQL Server Developer edition on Win XP, version 9.00.2050.00.
[quoted text clipped - 4 lines]
> Thanks,
> Yash

Reply to this Message

Yashgt - 14 May 2008 05:18 GMT

Thanks. That worked.

On May 14, 8:13 am, "Aaron Bertrand [SQL Server MVP]"
<ten....@dnartreb.noraa> wrote:

> You need exclusive access to the database in order to enable the broker.
>
[quoted text clipped - 15 lines]
> > Thanks,
> > Yash

Reply to this Message