Stack Overflow
Stack Overflow

Questions tagged [service-broker]

SQL Server Service Broker is a messaging framework built into SQL Server. It includes infrastructure for asynchronous programming that can be used for applications within a single database or a single instance as well as for distributed applications.

576 questions
14
votes
1 answer

How to use SqlCacheDependency?

I need to implement SqlCacheDependency for a table which will depend on this query: SELECT Nickname FROM dbo.[User]. I have created a method for this purpose: private IEnumerable GetNicknamesFromCache() { const String…
Volodymyr Machula
  • 1,564
  • 1
  • 15
  • 20
13
votes
1 answer

SQL Service Broker and .NET Windows Service - Best practices?

I currently have a database that gets updated from a legacy application. I'd like to utilize a SQL Service Broker queue so that when a record is updated, a message is placed in the queue (using a trigger or something). I would then like to have a…
MrDustpan
  • 5,508
  • 6
  • 34
  • 39
12
votes
2 answers

to MSMQ or not to MSMQ? (or SQL Table as the Queue)

I've got a distributed system where there will be 1 SQL Server, 1-n processing servers, and 1-n data suppliers (hardware devices across the network). The data being supplied will require processing prior to going into the relational DB structure -…
Ed Sinek
  • 4,829
  • 10
  • 53
  • 81
12
votes
1 answer

How to check if my Queue (Service Broker) is enable or not?

rarely, for reasons that have not yet identified, my queue is disabled, when this happend, I enable again with this query: ALTER QUEUE [MyQueue] WITH STATUS = ON; but, i want to know when the queue is disabled, such as an event (T-SQL), or check…
makitocode
  • 938
  • 1
  • 16
  • 40
9
votes
2 answers

Is it possible to add SignalR messages directly to the SQL Backplane?

I'd like to know if I can add SignalR messages directly to the SignalR SQL Backplane (from SQL) so I don't have to use a SignalR client to do so. My situation is that I have an activated stored procedure for a SQL Service Broker queue, and when it…
Novox
  • 774
  • 2
  • 7
  • 24
9
votes
1 answer

SQL Service Broker as a generic Enterprise Message Bus for .net

I'm in need of an Enterprise Service Bus/Message Queueing solution for publisher/subscriber functionality. I know MANY exist... MSMQ, MS Series, RabbitMQ, NServiceBus, etc etc etc... My one requirement is that in a shared hosting solution, the only…
Novox
  • 774
  • 2
  • 7
  • 24
9
votes
1 answer

Sql Server Service Broker Conversation Groups

Can someone explain conversation groups in service broker? Currently, I'm using service broker to send messages from one SQL server to another. On the sending server, I'm trying to correlate the messages so they are processed in serial on the…
Brian Hasden
  • 4,050
  • 2
  • 31
  • 37
8
votes
2 answers

Service Broker And Web services

I want to implement a stored procedure (within a service broker infrasturture) which calls a web service. I looked some examples from Aschenbrenner's book on Service Broker. However I don't find any with a web service call. Could anyone…
user409679
  • 81
  • 1
  • 3
8
votes
2 answers

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 local service targeted by this dialog." If I re-enable one of the problem queues (there are five) and leave Activation set to OFF, the…
Aushin
  • 1,198
  • 1
  • 7
  • 12
7
votes
4 answers

.NET API for SQL Server Service Broker

Is there a .NET API or object model for using SQL Server Service Broker?
duraid
  • 614
  • 7
  • 16
7
votes
1 answer

Will SQL Server Service Broker be supported in SQL Azure in future?

I found that SQL Server Service Broker is not supported in SQL Azure. Service Broker is a very attractive choice for our event notification needs. But before committing to it I wanted to make sure it will be supported by Microsoft in the future. The…
Sathish
  • 101
  • 2
  • 6
7
votes
5 answers

SqlDependency simple select query always returns "Invalid"

I'm trying to get the SqlDependency object to give me notifications, but so far I'm not able to get it working. the sql query that I'm sending is this: SELECT [SocialMedia].[dbo].[Items].[Id] FROM [SocialMedia].[dbo].[Items] I've tried it w/ and…
joe_coolish
  • 7,201
  • 13
  • 64
  • 111
6
votes
1 answer

MSMQ vs. SQL Server Service Broker

I have an application that consists of three parts: a front-end web shop for end-users and business partners an order-management system to handle those orders a technical database system to handle all the technical details of those products and…
marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
6
votes
1 answer

How can I check in c# if Broker Service is enabled in SQL?

I want to check if Broker Service is running using code and depending on the status, start sqldependency or not. How can I do that?
IamDeveloper
  • 5,156
  • 6
  • 34
  • 50
6
votes
1 answer

Architecture recommendation using SQL Server for real-time aggregation and denormalization

We have an enterprise LOB application for managing millions of bibliographic (lots of text) records using SQLServer (2008). The database is very normalized (a complete record might easily be made of up ten joined tables plus nested collections).…
mdisibio
  • 3,148
  • 31
  • 47
1
2
3
…
38 39