service-broker

SQL Server Service Broker

Were there any major or really cool features added to SQL Server Service Broker in 2008? ...

SQL Server Service Broker Issue & Tutorials

I've been looking into implementing an external activator in SQL Server Express 2005, and I added the queues, services, contracts, and event notifications to the database. I also added a trigger to send a message to the target queue. Everything parses, runs, and the trigger is firing. However, when I select from the target queue, or use ...

Architecting a Work Item Processing System with Modified FIFO Semantics in Windows

I’m building a system that generates “work items” that are queued up for back-end processing. I recently completed a system that had the same requirements and came up with an architecture that I don’t feel is optimal and was hoping for some advice for this new system. Work items are queued up centrally and need to be processed in an es...

Should I use MSMQ or SQL Service Broker for transactions?

Hey Stackoverflow, I've been asked by my team leader to investigate MSMQ as an option for the new version of our product. We use SQL Service Broker in our current version. I've done my fair share of experimentation and Googling to find which product is better for my needs, but I thought I'd ask the best site I know for programming answe...

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 long running application (Windows service written in .NET) that is constantly "listening" ...

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 a lot, as I thought that more people would be using it. My experience with SB is that ...

MSSQL Service broker activation "Execute as SELF"

I have a service broker activated stored procdedure that runs fine when executed in management studio. However, when it is activated on the queue, the sql server error log shows the following message: "The activated proc [dbo].[FileUploadAsyncWorker] running on queue AsyncProcessing.dbo.FileUploadRequestQueue output the following: 'You...

.Net database message brokering

I'm looking for a simple and reliable mechanism to perform application message brokering from the database level. I basically need changes in two distinct applications to generate messages to each other to indicate that changes have occurred between their common objects. The difficulty lies in the fact that both systems have their own un...

How to reduce flooding a Service Broker queue?

I'm new to using the SQL Service 2005 Service Broker. I've created queues and successfully got conversations going, etc. However, I want to sort of "throttle" messages, and I'm not sure how to go about that. Messages are sent by a stored proc which is called by a multi-user application. Say 20 users cause this proc to be called once ...

Difference between a Message Broker and an ESB

Dear All, I have gone through different questions/articles on Message Brokers and ESBs(Even on stackoverflow). Still not a clue as what is the CLEAR demarcating difference between an Message Broker and an ESB? Now here I am trying to compare products, Websphere Broker and Mule ESB!! Firstly , is (any version) Webshere Broker an ESB? O...

sql service broker functionality question

Hi, I'm a beginning web developer sitting on an ambitious web application project. So after having done some research, I found out about SQL Service Broker. It seems like something I could use, but I'm not sure. Since learning it requires someone to put in lots of time, I wanted to be sure that it would fit my needs. I need to implemen...

Private Key issue in Service Broker

We are trying to make conversation between two SQL instances in one SQL Engine through Service Broker by following tutorial from MSDN. In order to make it simple , we send the dialog with Encryption = OFF so we do not need to deal with Master key , Certificate... and it works in the local workstation. DECLARE @InitDlgHandle UNIQUEIDEN...

Query Notification Error

Hi, We have this weird issue regarding SQL Query Notification service. We have a main web application running with QN service so the cache item in the web get notification from SQL when the monitoring data changed. And it runs well. What is weird is when the other supporting web service tries to register QN subscription into SQL...

Chinese Characters in SQL Service Broker Message

I have setup multiple SQL Service Broker Queues in a database but have not seen this problem before. A message containing XML is being converted to what appears to be mostly Chinese Characters. When I check the variable that is storing the XML prior to putting it in the message queue I can see that is in English and is well XML formed. W...

Service Broker with Sql Server 2005 - Messages stuck in queue

Hi! I'm configuring a simple service broker implementation. Locally, we use SQL Server 2008 Express and everything works fine. Once the code runs on our production server (SQL SERVER 2005), messages are stuck in the receiver queue. The followind code is incomplete but states how queues and services are basically configured: -- Create m...

Sql Server Service Broker: How to structure Conversations for a simple queue scenario?

I'm a Sql Server Service Broker novice and I'm trying to grasp the best way to set Service Broker up for a (seemingly) simple use case: I want to create a simple work queue, where one application drops work items into the queue, and separate application picks up work items from that queue and processes them. There is no need for the firs...

Anyone ever try this: Custom VirtualPathProvider (SQL Based) with SqlCacheDependency, SQL2005 and Service Broker?

I've been toying with the VirtualPathProvider the last couple of days and have gotten to the stage where I'm serving my aspx files from a SQL database but am stuck when it come to a method of invalidating the ASP.NET cache whenever a row on my database changes. So far I've managed to get it working using the SQL2000 method of SqlCacheDe...

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 receiving side. Based on the documentation, conversation groups seem to be a perfect fit for t...

Make Service Broker Be Less Aggressive About Detecting Poison Messages?

Sql Service Broker uses the following heuristic to determine when you have messages in your queue that are preventing your application from doing any useful work: "Service Broker provides automatic poison message detection. When a transaction that contains a RECEIVE statement rolls back five times, Service Broker disables all queues tha...

SQL Server Message Broker - External Activation

I have a Sql Server inside a restricted network. I need to somehow get data from the outside in. I would like to harness the use of Message Broker. My thinking is the external db places a message on a queue then I require a service that sits inside of the restricted LAN to listen (poll?) for these messages and then act upon them. I can...