Alter Database xxx set enable

Alter Database xxx set enable_broker

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John Cantley - 10 Jan 2008 16:58 GMT

I am setting up service broker to replace a batch job. I got everything set
up and ready to go. When I did my first message test I get broker not
enabled in the transmission_queue. So I found this statement

Alter database xxx set Enable_Broker With Rollback Immediate.
All this does is enable the broker, correct? I need to kick everyone out of
the test db and then set the enable_broker. Is that all it will do. I don't
want it wiping out everything.

Thanks, JC

Reply to this Message

Adam Machanic - 10 Jan 2008 18:18 GMT

It will both kick everyone out and enable SSB, yes. It will not delete any
data.

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 setting up service broker to replace a batch job. I got everything set
>up and ready to go. When I did my first message test I get broker not
[quoted text clipped - 6 lines]
>
> Thanks, JC

Reply to this Message

Tibor Karaszi - 11 Jan 2008 05:38 GMT

... except for open connection with work performed which hasn't been committed yet... :-)

Signature

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

> It will both kick everyone out and enable SSB, yes. It will not delete any data.
>
[quoted text clipped - 7 lines]
>>
>> Thanks, JC

Reply to this Message

Adam Machanic - 11 Jan 2008 14:31 GMT

Well if the work hasn't been committed than arguably it's still not deleting
anything <g>

Signature

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

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

> ... except for open connection with work performed which hasn't been
> committed yet... :-)
[quoted text clipped - 12 lines]
>>>
>>> Thanks, JC

Reply to this Message

Tibor Karaszi - 11 Jan 2008 14:55 GMT

Semantics... :-)

Signature

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

> Well if the work hasn't been committed than arguably it's still not deleting anything <g>
>
[quoted text clipped - 11 lines]
>>>>
>>>> Thanks, JC

Reply to this Message