provides the infrastructure for queue-based asynchronous message communication between databases.

learn more… | top users | synonyms

2
votes
1answer
29 views

What are the requirements to installing Sql Server Service Broker External Activator on a remote machine?

I have implemented Service Broker on one of my databases, and have successfully processed messages with my own c# application by following this tutorial. ...
4
votes
1answer
63 views

sa doesn't have permissions to other database through synonyms with the Service Broker

I've been trying to get this Service Broker and timers thing to work for over a week straight now, so bear with me if this comes off as.. uh.. ragey. I'm also fairly inexperienced when it comes to SQL ...
1
vote
1answer
18 views

Does setting a database to single_user prevent delivery of Service Broker messages?

Is it safe to assume that while a database is in single_user mode, the queues are not available for message delivery? My understanding is that the special tables that the queues represent reside in ...
0
votes
0answers
12 views

Diagnosing SSBDIAGNOSE?

When trying to connect SSBDIAGNOSE from a command shell to a named instance on the same server(to which my Windows Login has SA), I receive an error e.g. SSBDIAGNOSE CONFIGURATION FROM SERVICE ...
0
votes
0answers
15 views

Service broker - Reusing conversation - Problem of deadlock

I am re using the conversation as per Remus Rusanu's blog http://rusanu.com/2007/05/03/recycling-conversations/. The event flows from initiator to target. Please note that my service broker ...
0
votes
0answers
14 views

Odd service broker behavior

I have an established service broker relationship between two databases in our production environment. We do a weekly restore of these databases to another server for the purposes of testing our ...
0
votes
0answers
21 views

How to pass parameters to a cmd.exe using Servcice Broker External Activator

I am trying to use SQL Server Broker External Activator to launch C:\Windows\System32\cmd.exe application and pass commands to it. For example: echo Hello World x 2 >C:\Test\cmd1executed.txt To do ...
0
votes
0answers
76 views

How to implement SQL Server Service Broker with external activator

I am trying to execute an external app using SQL Server Service Broker and the External Activator provided by Microsoft. I have created the following script: IF EXISTS (SELECT * FROM sys.databases ...
0
votes
1answer
47 views

SQL Server service broker related rights issue

CREATE PROCEDURE [dbo].[stproc_ssb_send] @iname varchar(20) WITH EXECUTE AS 'xyz' AS BEGIN DECLARE @DIALOG_HANDLE UNIQUEIDENTIFIER DECLARE @MSG varchar(max) SET @MSG='<MESSAGE> ...
3
votes
1answer
49 views

SQL Server Service Broker - CHECKDB found consistency errors, how could this happen?

I encountered a weird SQL Server Service Broker consistency problem, namely I have a queue that holds messages (status=1, Ready to receive) which are lying there for a very long time. In the ...
1
vote
0answers
29 views

service broker/resource govenor

Is it possible to configure service broker to work with resource governor? Currently all commands are being sent to the internal group but I want them to go elsewhere.
0
votes
0answers
18 views

Service Broker and Windows Compatibility

I understand that Service Broker cannot tell the difference between SQL Server versions, but would the windows server versions have any effect on sending messages through service broker? I have SQL ...
0
votes
0answers
112 views

Service Broker and “the module being executed is not trusted”

We are having an issue executing a stored procedure from a queue in the SQL Service Broker. Trying to execute the following stored procedure: EXEC usp_StoredProcedureQueue_Enqueue ...
2
votes
1answer
84 views

Sql Service broker BEGIN DIALOG CONVERSATION and SEND. Should they be in a transaction?

I regularly see code that looks like this: BEGIN TRANSACTION; BEGIN DIALOG CONVERSATION @u.... SEND ... COMMIT; BOL for BEGIN DIALOG doesn't use the transaction handling in the examples and it ...
3
votes
1answer
302 views

How to suppress activation procedure output from the error log?

I found so many below informational messages (bulk messages with no any error) are logged in the SQL Server error log. The activated proc 'x' running on queue 'y' output the following: 'z' I ...
0
votes
1answer
29 views

Service Broker and procedure which contains Execute as

We have queue on Service Broker: ALTER QUEUE [dbo].[my_queue] WITH STATUS = ON , RETENTION = OFF , ACTIVATION ( STATUS = ON , ...
11
votes
0answers
180 views

Service broker was backed up, now receiving, but doesn't seem to be processing

Having a problem with Event Notifications. On the machine/drive/database that the messages are sent to (receiver), the drive filled up when nobody was looking, so it's been backed up all day. Now ...
2
votes
2answers
135 views

Trigger to create a variable Table to be sent to service broker

I've setup a service broker for the first time and tested it... Looks good. Everytime a DML operation happens on a specific table; Let's say the Price Table, a trigger calls a stored procedure passing ...
0
votes
0answers
25 views

Service Broker -

SQL 2008 R2, clustered and mirrored. We recently switched data centers, and Service Broker is now failing to receive messages sent from another instance on the same cluster. This was working for the ...
0
votes
1answer
3k views

Launching a python script from an insert trigger [closed]

We have a nice piece of python that sends some emails and interacts with a cloud system. Works fine. But we have to fire it every few minutes to poll the db. We really need, for business purposes, to ...
4
votes
1answer
82 views

Should Service Broker use SQL or Windows Authentication?

I was curious what the best practice would be, for properly setting up Service Broker in SQL Server 2008. Should I use a SQL authenticated user, or should I use a Windows NT Authenticated user based ...
4
votes
1answer
89 views

Query Notification setup

I am relatively new at playing around with this and have been trying to follow a tutorial on setting up in the section named "Prerequisites to Create SQL Notification Requests" within this site ...
6
votes
1answer
356 views

No service broker active on database

I am trying to set up query notification however when I try to create a queue and service I get the error 'There is no Service Broker active in the database. Change to a database context that contains ...
1
vote
2answers
2k views

sql server removing service_queues

When I query select * from sys.service_queues in SQL Server 2008 sp3, I am getting: InternalMailQueue ExternalMailQueue _LakeSide_DbTools_DeadlockQueue QueryNotificationErrorsQueue ...
2
votes
0answers
1k views

The Service Broker endpoint is in disabled or stopped state - AoAG - SQL Server 2012 - 15 minute interval

I receive this error message in SQL Server error log every 15 minutes. I have setup AOAG on this server. The database option "Service Broker - Broker Enabled" is turned on for the Blackberry related ...
2
votes
1answer
4k views

Permissions using .NET SqlDependency

SQLDependency Notifications work fine logged in as Windows Domain User, using Trusted Connection. But not as SQL-User: I created a db login, user and role as follows: CREATE LOGIN myLogin WITH ...
1
vote
1answer
308 views

SQL Service Broker and AlwaysOn Issue

I'm having an issue setting up my current environment using AlwaysOn and SSB and I'll try to explain as best as I can here: Current environment: Server A Server B database x(Pub) ...
0
votes
1answer
63 views

Best practice to recover an CRUD statement to a linked server if connection is lost

I am looking for the best practice for the following scenario. We have a CRM in our company. When an employee updates the record of a company, there is trigger that fires a stored procedure which has ...
4
votes
0answers
82 views

Take action from extended event?

I've seen it mentioned a few times that you can configure an event session to take an action when an event fires. Does anyone have any information on how to do this? I know that you can use the ...
1
vote
0answers
41 views

How to architect Service Broker with three or more systems?

I'm trying to implement a Service Broker architecture for a business process involving three systems and I want to do it in the spirit of using SB as designed. System 'A' is an accounting system. ...
1
vote
1answer
176 views

SQL Service Broker & Logical File Names

A colleague was having trouble enabling the Service Broker for a particular database. SQL Server kept on throwing an error stating that the Service Broker was already running. When checking the ...
4
votes
1answer
182 views

SQL Server Service Broker Compatability across versions?

I'm planning a project to upgrade internally-developed app from SQL Server 2005 to SQL Server 2012. I hope to use Service Broker as a bridge while in transition. Are there any issues to consider in a ...
1
vote
1answer
2k views

Service Broker User Does Not Have Permission to Send to the Service

I am using .NET SqlDependency with a named queue (not dynamically created). My Service Broker Configuration Is CREATE QUEUE dbo.SqlDependencyQueue; GO CREATE SERVICE SqlDependencyService ...
2
votes
0answers
165 views

Impact of Service Broker on Server Performance [closed]

For DDL auditing we are thinking to use service broker, but I want to check few parameters before deploying it to a production server, where there are about 200 DBs and Standard Edition of SQL Server. ...
1
vote
0answers
110 views

Best implementation of Service Broker when multiple readers needs to read their own message

I have implemented service broker using rusanu.com articles and advices. Now I need to implement the following scenario : The service broker will manage Many messages for differents workers and each ...
1
vote
1answer
240 views

sql server service broker

For the last few days the service broker command which run from master database is consuming much more RESOURCES than before. The Impact on the Database is high (from the bad side), It causes for ...
0
votes
0answers
484 views

Service Broker received an error message on this conversation

I will first have to say, I am still trying to wrap my brain around all the components of the Service Broker and how they work together, so it's very likely I'm missing something obvious... it's just ...
2
votes
0answers
99 views

Service broker routes and DNS

Apologies for the long post but I've recently seen some strange behaviour with Service Broker when the routes it uses reference a DNS entry, and I am wondering if anyone has seen the same? We have ...
1
vote
1answer
224 views

Do SELECT (without ORDER BY) return the same message as RECEIVE?

My current client needs to be able to PEEK messages in a SQL Server Service Broker queue. The current implementation uses RECEIVE and rollback to peek. As that generates writes to the transaction ...
11
votes
1answer
1k views

Sch-M WAIT blocks Sch-S in SQL Server 2014 but not SQL Server 2008 R2?

We recently migrated our production instances from SQL 2008 R2 to brand new SQL 2014 servers. Here is an interesting scenario that we uncovered with our usage of Service Broker. Consider a database ...
1
vote
1answer
169 views

High Service Broker queue

My production database suffers from a large Service Broker message queue. It is around 2 million. I would like to decrease it as small as possible. I have tried dbcc ...
1
vote
1answer
123 views

It is mandatory to create a route when creating an event notification?

I'm starting with service broker. Already managed to setup an event notification for blocked processes based on this answer and it's working flawlessly. Then I wanted to setup another one to notify ...
2
votes
2answers
4k views

Why does the service broker require a master key after restoring to a different server?

I've been moving some databases which use the service broker to new servers recently via backup and restore. I've noticed that once I do this, these databases start throwing the database master key ...
0
votes
1answer
207 views

Do I need to have two queues for Service Broker?

I am just starting with Service Broker and looking at the examples in blogs, most have a sending and receiving service with separate queues. Looking at the SEND TO command (to send a message) I need ...
4
votes
1answer
2k views

SQL Server CPU spikes - possibly non-query related - suggested indicators

I'm looking for suggestions for indicators I could monitor to discover what is causing these cpu "blunted spikes". Some known information: sqlserver.exe is confirmed as the process consuming the ...
7
votes
1answer
1k views

Service Broker: Queue Monitor is dropped after poison message

I have searched everywhere and there isn't an answer online. There is one similar question on stackoverflow but it's not exactly the same and it has no accepted answer. When I setup event ...
3
votes
1answer
2k views

sql server service broker queue pass parameter to stored procedure

Stored Procedure Create PROCEDURE [dbo].[InitServiceLog] ( @name varchar(max)=null ) AS BEGIN SET NOCOUNT ON; insert into [AdventureWorks].[dbo].[ServiceBroker_Log](Service) ...
1
vote
0answers
1k views

SQL Server Service Broker messages in one database fails unless SA owns the database? What's going on here?

I've been attempting to learn how to set up Service Broker through Microsoft's "Completing a Conversation in a Single Database" tutorial. However, when I actually try to send a message, it fails until ...
2
votes
1answer
1k views

Service Broker stops working [closed]

I'm new to Service Broker. Our existing Service Broker suddenly stops working and I can't figure out why. When I try to enable Service Broker (which is already enabled) I get this in SQL error log: ...
4
votes
0answers
209 views

ENABLE_BROKER vs NORECOVERY

I have two nodes with MSSQL2012 which work with AlwaysOn High Availability After some crash I had to remove db from availability group on the one of the nodes. For restoration I've made backup ...