<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Mayank Parmar
»
Enable Broker Service
30 posts, Page 1 of 3
1
2
3
»
»»
Enable Broker Service
Rate Topic
Display Mode
Topic Options
Author
Message
Mayank Parmar
Mayank Parmar
Posted Monday, October 25, 2010 10:44 PM
Say Hey Kid
Group: General Forum Members
Last Login: Wednesday, September 21, 2011 4:03 AM
Points: 713,
Visits: 100
Comments posted to this topic are about the item
Enable Broker Service
--------------------------------------------------------------------------------
Mayank Parmar
Software Engineer
Clarion Technologies
SEI CMMI Level 3 Company
8th Floor, 803, GNFC info Tower,
SG Highway, Ahmedabad - 380 054,
Gujarat, India.
www.clariontechnologies.co.in
Email: mayank.parmar@clariontechnologies.co.in
MSN : mayank.parmar@clariontechnologies.co.in
Mobile: +91 9727748789
--------------------------------------------------------------------------------
Post #1010524
UMG Developer
UMG Developer
Posted Monday, October 25, 2010 11:13 PM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 2:49 PM
Points: 2,163,
Visits: 2,150
Nice question on something most people probably don't know anything about. Thanks!
Post #1010530
Iulian -207023
Iulian -207023
Posted Monday, October 25, 2010 11:55 PM
SSC Eights!
Group: General Forum Members
Last Login: Thursday, June 13, 2013 6:47 AM
Points: 847,
Visits: 770
Nice question, thanks.
Here is also a discussion on this topic:
http://social.msdn.microsoft.com/Forums/en-US/sqlservicebroker/thread/eca47504-9a8c-4c0f-a4a4-3a56fb5a012b
Post #1010541
Imran Ashraf-452633
Imran Ashraf-452633
Posted Tuesday, October 26, 2010 12:33 AM
Ten Centuries
Group: General Forum Members
Last Login: 2 days ago @ 9:00 AM
Points: 1,103,
Visits: 416
Another Good question, one which I needed to read up about as we do not use the Service Broker where I work.
Post #1010552
Hardy21
Hardy21
Posted Tuesday, October 26, 2010 12:45 AM
SSC Eights!
Group: General Forum Members
Last Login: Wednesday, May 22, 2013 7:11 AM
Points: 877,
Visits: 1,159
Good question with nice/tricky options.
I was thinking for following options are the candidates:
ALTER DATABASE db2 SET DISABLE_BROKER ; ALTER DATABASE db2 SET ENABLE_BROKER;
ALTER DATABASE db2 SET NEW_BROKER
But after reading some links got the right answer - NEW_BROKER.
Thanks
Post #1010554
Nakul Vachhrajani
Nakul Vachhrajani
Posted Tuesday, October 26, 2010 1:32 AM
Ten Centuries
Group: General Forum Members
Last Login: Monday, June 10, 2013 6:56 AM
Points: 1,282,
Visits: 1,613
Great question!
The Enable broker and new broker were obvious candidates, but it took some Books On line reading to get to NEW_BROKER.
Got to learn something new on Service Broker today. Thank-you!
Thanks & Regards,
Nakul Vachhrajani.
http://beyondrelational.com/modules/2/blogs/77/nakuls-blog.aspx
Be courteous. Drive responsibly.
Follow me on
Twitter:
@nakulv_sql
Google Plus:
+Nakul
Post #1010571
Koen Verbeeck
Koen Verbeeck
Posted Tuesday, October 26, 2010 1:40 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Yesterday @ 6:30 AM
Points: 9,410,
Visits: 6,495
Nice question about an unknown subject.
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1010575
Phil Jackson
Phil Jackson
Posted Tuesday, October 26, 2010 2:34 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Thursday, February 07, 2013 5:12 AM
Points: 509,
Visits: 182
I'm sorry, but I do not believe that the question was phrased very well. To 'enable' Service Broker for the database, you use the ENABLE_BROKER option, as stated in the msdn article you posted [url=http://msdn.microsoft.com/en-us/library/bb522682(v=SQL.100).aspx][/url]
ENABLE_BROKER
Specifies that Service Broker is enabled for the specified database. Message delivery is started, and the is_broker_enabled flag is set to true in the sys.databases catalog view. The database retains the existing Service Broker identifier.
To reset/assign a new Service Broker Id for a restored database, you would use the NEW_BROKER option.
NEW_BROKER
Specifies that the database should receive a new broker identifier. Because the database is considered to be a new service broker, all existing conversations in the database are immediately removed without producing end dialog messages. Any route that references the old Service Broker identifier must be re-created with the new identifier.
Phil
Although all answers are replies, not all replies are answers.
Blog: http://philjax.wordpress.com
Post #1010594
Christian Buettner-167247
Christian Buettner-167247
Posted Tuesday, October 26, 2010 2:40 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 12:36 AM
Points: 2,547,
Visits: 3,648
<nitpick mode="on" />
I would issue a simple
ALTER DATABASE db2 SET ENABLE_BROKER
, since noone said that the broker service had already been enabled in db1
<nitpick mode="off" />
Ok, common sense told me that I should assume the service had already been enabled in db1 as well, so I chose the right answer.
Best Regards,
Chris Büttner
Post #1010597
Mayank Parmar
Mayank Parmar
Posted Tuesday, October 26, 2010 2:41 AM
Say Hey Kid
Group: General Forum Members
Last Login: Wednesday, September 21, 2011 4:03 AM
Points: 713,
Visits: 100
Yes Phil,
Normally to enable the Broker Service, you need to simply use : "ENABLE_BROKER"
But when you restore the back up of database db1 to database db2, and after that if you want to enable broker service on database db2, then what to do? - That was my question.
Regards,
Mayank
--------------------------------------------------------------------------------
Mayank Parmar
Software Engineer
Clarion Technologies
SEI CMMI Level 3 Company
8th Floor, 803, GNFC info Tower,
SG Highway, Ahmedabad - 380 054,
Gujarat, India.
www.clariontechnologies.co.in
Email: mayank.parmar@clariontechnologies.co.in
MSN : mayank.parmar@clariontechnologies.co.in
Mobile: +91 9727748789
--------------------------------------------------------------------------------
Post #1010601
« Prev Topic
|
Next Topic »
30 posts, Page 1 of 3
1
2
3
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
