Discussions about service broker

.Net API for SQL Service Broker Is there a .Net API or object model for using SQL Service Broker? Started by Delucia on Monday, January 18, 2010, 3 posts by 3 people.   Read the full thread at stackoverflow Discuss this with your friends on Facebook Answer Snippets (Read the full thread at stackoverflow): There are some community samples though which are developed by the Service Broker team or related teams in MS which you and report a bug).... There isn't any official supported API. Reference here: SQL Server Service Broker .

MSSQL 2005 Service Broker failing to start I'm getting complaints from my MSSQL 2005 Standard machines that they cannot start the service broker, followed by a message from the service broker manager: Jul 20 08:35:47 sql3 MSSQL$SQL3: 9697: Could not start Service Broker for database id: 5763. ... Started by on Monday, July 20, 2009, 4 posts by 4 people.   Read the full thread at serverfault Discuss this with your friends on Facebook Answer Snippets (Read the full thread at serverfault): Can you check in sys.databases service_broker_guid if you have any. 3602? That is weird indeed.

SQL Server Service Broker Were there any major or really cool features added to SQL Server Service Broker in 2008? Started by therealhoff on Thursday, September 18, 2008, 3 posts by 3 people.   Read the full thread at stackoverflow Discuss this with your friends on Facebook Answer Snippets (Read the full thread at stackoverflow): Specifies a priority level and the criteria for determining which Service Broker conversations to assign/archive/2007/12/21/sql-server-service-broker-2008-conversation-priorities.aspx The diagnostics tool ssbdiagnose ..

Can you/should you use SQL Server Service Broker with .NET applications? I have many operations in the database that need to trigger application code. Currently I am using database polling, but I hear that SQL Server Service Broker can give me MSMQ-like functionality. Can I listen to SQL Server Service Broker queues from .... Started by Jonathan Allen on Monday, September 21, 2009, 3 posts by 3 people.   Read the full thread at stackoverflow Discuss this with your friends on Facebook Answer Snippets (Read the full thread at stackoverflow): To answer your questions: Can I .... SSB (SQL Service Broker) has a feature named Activation that enabled a stored procedure of an External Activator for Service Broker that leverages the event notification mechanism to know .

SQL Server Service Broker -- Communicating Between Non-Domain Servers Over a VPN Are there any good options for connecting two SQL Server 2008 instances via Service Broker if neither of those servers are in a domain, but we have full control over the logins and credentials? We're thinking of using this technology for enterprise-level... Started by mwigdahl on Tuesday, February 16, 2010, 3 posts by 3 people.   Read the full thread at stackoverflow Discuss this with your friends on Facebook Answer Snippets (Read the full thread at stackoverflow): You use certificates, which is the Service Broker authentication option = '20150216'; create endpoint broker state = started as tcp (listenner_port = 4022) for service_broker endpoint broker.... And some example here.

Is anyone using the Service Broker in SQL Server? Hi all! When I attended a presentation of SQL Server 2008 at Microsoft, they did a quick gallup to see what features we were using. It turned out that in the entire lecture hall, my company was the only one using the Service Broker. This surprised me ... Started by Jonas Lincoln on Tuesday, February 03, 2009, 6 posts by 6 people.   Read the full thread at stackoverflow Discuss this with your friends on Facebook Answer Snippets (Read the full thread at stackoverflow): I even.... We sent out to the customers. I've been using SQL Service Broker since a couple of months after SQL 2005 was released. I have recently considered using Service Broker for a project, but yes, decided to go for MSMQ it.

Best ORM that can work with Service Broker and transactions Greetings Is there a ORM (MS-Sql specific) that can work with transactions and is Service Broker friendly. What I’m searching for is the ability to work with the ORM tables, inside a transaction, and be able to do service broker calls inside the transaction... Started by Joe on Thursday, December 24, 2009, 3 posts by 3 people.   Read the full thread at stackoverflow Discuss this with your friends on Facebook Answer Snippets (Read the full thread at stackoverflow): So I'd focus on different criteria for choosing ORM ;) . Almost any ORM supports this - there is nothing special, you need just transactions support and direct SQL command execution . I would suggest NHibernate.

SQL Server service broker reporting as off when I have written a query to turn it on I have made a small ASP.NET website. It uses sqlcachedependency The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported. Please enable the Service Broker for this database if you wish... Started by dotnetdev on Friday, August 21, 2009, 3 posts by 3 people.   Read the full thread at stackoverflow Discuss this with your friends on Facebook Answer Snippets (Read the full thread at stackoverflow): Ditch the "with rollback immediate" and try. Time the instance is created, the Service Broker gets disabled each time because attach and restore operations always disable the broker in the database.

SQL Service Broker vs Custom Queue I am creating a mass mailer application, where a web application sets up a email template and then queues a bunch of email address for sending. The other side will be a Windows service (or exe) that will poll this queue, picking up the messages for sending... Started by Luke on Thursday, September 24, 2009, 4 posts by 4 people.   Read the full thread at stackoverflow Discuss this with your friends on Facebook Answer Snippets (Read the full thread at stackoverflow): I would not use MSMQ, if both the sender and the reader need a database . For advantages of Service Broker see this link: http://msdn.microsoft.com/en-us to the Service Broker Queues.

SQL Server Service Broker using DataSet Hi, I am converting a console application to run from Service Broker in SQL Server 2005. The application makes heavy use of DataSet . Are DataSets supposed to work in SQLCLR ? How do I define the connection to use? Is there any documentation about this... Started by Oli on Monday, September 14, 2009, 3 posts by 3 people.   Read the full thread at stackoverflow Discuss this with your friends on Facebook Answer Snippets (Read the full thread at stackoverflow): You question. What do you mean run FROM service broker? SB is in essence a message queuing system.