No announcements
Found 2909115 threads
-
15 VotesHow to enable service broker for specified database?
I did create this database from a backup of another database that had service broker enabled ...Answered | 6 Replies | 215514 Views | Created by Michael_Shao - Thursday, December 21, 2006 5:31 AM | Last reply by Olaf Helper - Friday, October 6, 2017 1:46 PM
-
10 Votes
Msg 9772 -- Service Broker in database "" cannot be enabled
I backed up a database "Broker", and restored it on the same instance as "BrokerQA" (Broker db still exists, I need them both running on the same ...Answered | 3 Replies | 33635 Views | Created by PugV - Tuesday, November 29, 2005 3:18 PM | Last reply by heckubus4 - Tuesday, October 20, 2009 6:50 PM -
0 Votes
Service Broker and the master database
I do not want to use a specific user database for administration purposes like monitoring for blocking queries so I thought that master would be a good place to store that kind of ...Answered | 2 Replies | 9508 Views | Created by Lars Lindgren - Monday, October 5, 2009 8:05 AM | Last reply by Lars Lindgren - Tuesday, October 6, 2009 8:29 AM -
0 Votes
enable service broker in operations manager
Run the query:Answered | 2 Replies | 14752 Views | Created by JerryN_ISP - Thursday, November 18, 2010 8:04 PM | Last reply by JerryN_ISP - Thursday, November 18, 2010 8:41 PM -
0 Votes
Failure to deploy due to "no Service Broker active in the database".
How does that apply?Answered | 3 Replies | 6847 Views | Created by JerryNixon - Wednesday, September 23, 2009 4:29 PM | Last reply by tomsmi - Tuesday, October 20, 2009 7:45 PM -
3 Votes
Service Broker across database versions
This blog describes how to setup Secure SQL Server Service Broker across databases in less than 10 ...Answered | 2 Replies | 5204 Views | Created by Shival Mathur - Wednesday, October 17, 2012 6:19 AM | Last reply by Iric Wen - Thursday, October 18, 2012 7:44 AM -
0 Votes
Service Broker/Database Mirroring transport Error
An error occurred in a SQL Server Service Broker/Database Mirroring transport connection endpoint: An error occurred in a ...Answered | 3 Replies | 26658 Views | Created by reddyshekar - Thursday, September 20, 2012 11:52 AM | Last reply by lingamkrishna - Wednesday, April 10, 2013 5:24 PM -
0 Votes
Service Broker
So I don't understand how changing the owner once again to that user 'gbs' solves the problem.Answered | 4 Replies | 14567 Views | Created by After2050 - Thursday, May 28, 2009 5:54 AM | Last reply by After2050 - Friday, May 29, 2009 1:07 PM -
0 Votes
service broker
What are you trying to achieve by "executing one or more query with service broker", or more importantly, what do you mean by that question.Answered | 2 Replies | 7727 Views | Created by sma_jafari - Tuesday, June 26, 2012 11:51 AM | Last reply by Sanil Mhatre - Wednesday, June 27, 2012 6:08 PM -
0 Votes
service broker manager has started
Hi delenne, Since we don’t use Service Broker and received the error message relates to Service Broker, this can occur more likely that ...Answered | 1 Replies | 3984 Views | Created by delenne HAgh - Monday, October 14, 2013 9:52 AM | Last reply by Allen Li - MSFT - Tuesday, October 15, 2013 2:46 AM -
0 Votes
Can I enable broker on SQL Azure
You can see here that, Service Broker is one of the limitations of SQL Azure.Answered | 1 Replies | 10115 Views | Created by Orna Kahil - Sunday, January 30, 2011 12:09 PM | Last reply by Rajesh Kolla - Sunday, January 30, 2011 2:26 PM -
1 Votes
Service Broker
Hi Sanjeet, We can use Replication to maintain consistency between different databases.Answered | 2 Replies | 3922 Views | Created by Sanjeet Kumar Satpathy - Wednesday, May 8, 2013 7:25 AM | Last reply by Allen Li - MSFT - Thursday, May 9, 2013 2:05 AM -
0 Votes
How to work with the service broker
Answered | 1 Replies | 2985 Views | Created by compaqster - Tuesday, November 17, 2009 2:50 PM | Last reply by Tergiver - Tuesday, November 17, 2009 3:34 PM -
0 Votes
Service Broker: Database and Application in different servers
Hello, I used SQL Server's Service Broker feature in my application.Answered | 2 Replies | 9691 Views | Created by milax - Thursday, February 17, 2011 5:00 PM | Last reply by ClarenceTunstall - Thursday, March 17, 2011 3:08 PM -
0 Votes
sysxmitqueue grows huge on SQL server 2005 without service broker enabled
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/e89ed1c8-14a3-4ebf-9516-e90687d15dda/how-to-purge-sysxmitqueue-table-in-msdb-sql-server-2005?Answered | 2 Replies | 803 Views | Created by SRichards - Wednesday, August 10, 2016 6:55 PM | Last reply by S_NO - Thursday, August 11, 2016 8:39 AM -
1 Votes
Seen this statement being run - is something trying to use Service Broker?
Service Broker is enabled per database, not per server.Answered | 5 Replies | 1875 Views | Created by shiftbit - Thursday, June 18, 2015 5:36 PM | Last reply by davidbaxterbrowne - Friday, June 19, 2015 1:45 PM -
0 Votes
Service broker with alwayson
Is better to enable service broker with alwayson on before to create availability group?Answered | 11 Replies | 3283 Views | Created by Emanuele86 - Friday, May 3, 2019 1:28 PM | Last reply by Puzzle_Chen - Wednesday, May 15, 2019 1:25 AM -
1 Votes
alter database set New Broker
Enabling Service Broker requires exclusive access to the database so SET NEW_BROKER WITH ROLLBACK ...Answered | 1 Replies | 16728 Views | Created by subu999 - Wednesday, August 10, 2011 3:36 PM | Last reply by Chirag Shah - Wednesday, August 10, 2011 3:49 PM -
0 Votes
Service Broker vs Stream Insight
This really depends on what you're using service broker for.Answered | 1 Replies | 10011 Views | Created by Trinity2008 - Thursday, September 22, 2011 8:23 AM | Last reply by Mark Simms [MSFT] - Thursday, September 22, 2011 2:10 PM -
1 Votes
Service Broker and .Net
Do u have any sample or any recourse where i can get that how to read the data from Service Broker queue in .net code.Answered | 7 Replies | 17831 Views | Created by DaleTurley - Wednesday, February 3, 2010 4:31 PM | Last reply by Pawel Marciniak - Wednesday, September 8, 2010 5:20 PM - Items 1 to 20 of 2909115 Next ›
No announcements
