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
159
votes
4 answers

Enable SQL Server Broker taking too long

I have a Microsoft SQL server 2005 and I tried to enable Broker for my database with those T-SQL: SELECT name, is_broker_enabled FROM sys.databases -- checking its status 0 in my case ALTER DATABASE myDatabase SET ENABLE_BROKER The Alter…
David.Chu.ca
  • 37,408
  • 63
  • 148
  • 190
141
votes
7 answers

Difference between a Message Broker and an ESB

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,…
Franklin
  • 1,790
  • 2
  • 14
  • 17
38
votes
5 answers

Enabling broker after Restoring Sql Server DataBase

I have DataBase with enabled Service Broker. Then I want to restore my database in program from backup of other database, but after restoring(I restore on existing database name), my method, whitch enables Service Broker, puts this error: Msg…
vts123
  • 1,736
  • 6
  • 27
  • 41
35
votes
1 answer

Service Broker messages not being sent if target rebooted

At a high level, here is what is happening: We have two SQL Server 2008 R2 SP1 systems (Standard Edition on Windows NT 6.1 (Build 7601: Service Pack 1)) They are humming along just fine, communicating bi-directionally with no errors or issues. We…
user1745937
  • 461
  • 4
  • 6
26
votes
2 answers

SQL Server 2008 Service Broker tutorial -- cannot receive the message (exception in transmission_status)

I am learning how to use the Service Broker of SQL Server 2008 R2. When following the tutorial Completing a Conversation in a Single Database. Following the Lesson 1, I have successfully created the message types, contract, the queues and services.…
pepr
  • 20,112
  • 15
  • 76
  • 139
25
votes
4 answers

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. 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…
Ed Schwehm
  • 2,163
  • 4
  • 32
  • 55
25
votes
3 answers

I want my database (SQL) to notify or push updates to client application

I was developing this application on VB.net 2010 and SQL 2008. I wanted the clients to be notified for updates on the db, and the application used to check the db for changes in the specified minute using a timer, which really is not efficient. I…
mike.dev
  • 251
  • 1
  • 3
  • 4
23
votes
5 answers

Is anyone using the Service Broker in SQL Server?

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,…
Jonas Lincoln
  • 9,567
  • 9
  • 35
  • 49
23
votes
6 answers

Delete messages in service broker queue

I'd like to clear my queue in SQL Server Management Studio, but I don't want to delete the whole queue just the content in the queue (the messages).
senna
  • 319
  • 1
  • 4
  • 12
22
votes
1 answer

Disadvantages of SQL Server Service Broker

I have been doing r&d for the scope of SQL Server Service Broker to replace current messaging solution MSMQ. I want to know disadvantages of SQL Server Service Broker in contrast to MSMQ for following…
mit
  • 1,763
  • 4
  • 16
  • 27
22
votes
3 answers

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…
Jonathan Allen
  • 68,373
  • 70
  • 259
  • 447
19
votes
3 answers

What is Service Broker in SQL Server?

What is Service Broker in SQL Server and is it meaningful to enable it in a simple database, not in a distributed database?
Nasser Hadjloo
  • 12,312
  • 15
  • 69
  • 100
16
votes
2 answers

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 but I can't seem to get Service Broker set up on the new box. Have done the obvious (to me) things like Enabling Broker on the DB, dropping the route,…
roryok
  • 9,325
  • 17
  • 71
  • 138
16
votes
2 answers

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…
Chris
  • 9,986
  • 8
  • 48
  • 56
15
votes
2 answers

Calling SSIS with SSISDB implementation from SQL Server Service broker

The requirement is to call a web service through SSIS and calling the SSIS from a SQL Server Service Broker activated stored procedure. Here is what I have currently doing: Queue CREATE QUEUE [schema].[ProccessingQueue] WITH STATUS = ON ,…
Sukanta
  • 151
  • 6
1
2 3
…
38 39