Top "Service-broker" questions

SQL Server Service Broker is a messaging framework built into SQL Server.

How to use SqlCacheDependency?

I need to implement SqlCacheDependency for a table which will depend on this query: SELECT Nickname FROM dbo.[User]. I …

c# .net sql-server caching service-broker
Service Broker messages start to get hung up after about a day

I have an application that is using the Service Broker is SQL 2008. About once a day the database's performance starts …

sql-server service-broker sqldependency query-notifications
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 …

.net sql-server message-queue service-broker
Should I use MSMQ or SQL Service Broker for transactions?

I've been asked by my team leader to investigate MSMQ as an option for the new version of our product. …

sql transactions msmq service-broker
Service Broker not working after database restore

Have a working Service Broker set up on a server, we're in the process of moving to a new server …

sql-server service-broker
Error : When Using SqlDependency Without Providing an Options Value

I am working on query notification. I have created Queue, Service and Route in my Database. I am accessing my …

c# sql-server service-broker
Detect SQL database changes

Consider this example: INSERT INTO [Table] (column1) SELECT value1 If I were to execute this command in SSMS, in regards …

c# sql listener service-broker sqldependency
Service Broker with Sql Server 2005 - Messages stuck in queue

I'm configuring a simple service broker implementation. Locally, we use SQL Server 2008 Express and everything works fine. Once the code …

sql-server-2005 queue service-broker
Service broker queues are disabling themselves, can't unearth the reason

In sys.transmission_queue the only information I'm given is "One or more messages could not be delivered to the …

sql sql-server service-broker
Timeout Error - Sending mail through SQL Mail - Service Broker Queue

This is my first question! So I hope I provide enough information: We are attempting to send around 1000 emails by …

sql timeout service-broker