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

learn more… | top users | synonyms

4
votes
1answer
81 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
87 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 ...
3
votes
1answer
45 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 ...
2
votes
1answer
83 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 ...
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
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> ...
11
votes
0answers
177 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 ...
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 ...
4
votes
0answers
207 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 ...
3
votes
0answers
602 views

SqlDependency permissions

The db is SQL Server 2012. All data tables are in the dbo schema. All data access is done via stored procedures in a different schema (user rt). I want to add query notifications for some tables, so I ...
3
votes
0answers
876 views

Event Notification / Service Broker - no inserts anymore, “previously existing connection with the same peer”

I've been working on getting several servers to feed Event Notifications to a central server. Had everything working yesterday, then managed to break it. Dropping and recreating the ...
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
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
0answers
28 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.
1
vote
0answers
40 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
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
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 ...
1
vote
0answers
4k views

DELETE failed because the following SET options have incorrect settings: 'ANSI_NULLS'

I have inherited a few scripts that are pumped through a c#.NET custom app to update a SQL2005 SP3 database. One of these scripts does a deletion on a user table called msw_timer_task, based on a ...
1
vote
0answers
157 views

Monitor For Disabled Queue On RDS SQL Server

I would like to somehow get notification of a queue being disabled due to poisoned messages. (The issue is occasional resource contention. Until we solve it, monitoring would help us be aware.) In my ...
1
vote
0answers
657 views

Can the service-broker cause SQL Server to crash when using SQLDependency

I have C# application that uses SQLDependency to get updates from a message table. I have tested it quite extensively and worked great in the development environment but when I ran it on the ...
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
13 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
66 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
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
109 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 ...
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
0answers
477 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 ...