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

learn more… | top users | synonyms

0
votes
0answers
10 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
25 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 ...
-1
votes
0answers
23 views

Service Broker needs to access the master key in the database

How do i resolve this error? I am using SQL Server 2014 and the database is trust worthy. The master key in the database 'database_name'. Error code:32. The master key has to exist and the service ...
3
votes
1answer
18 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 ...
0
votes
1answer
46 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> ...
1
vote
0answers
24 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
13 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
56 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
57 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 ...
4
votes
1answer
38 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 ...
11
votes
0answers
106 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
84 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
1answer
25 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 , ...
0
votes
0answers
22 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 ...
4
votes
1answer
59 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 ...
6
votes
1answer
231 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 ...
4
votes
1answer
80 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 ...
1
vote
0answers
936 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 ...
1
vote
1answer
233 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
0answers
37 views

Service Broker Queue Monitors Disappearing

We are experiencing a strange issue with Service Broker. We have a SQL 2005 database that was upgraded/migrated to a new SQL 2008 R2 environment (compatibility level changed as well). In this ...
0
votes
1answer
59 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
77 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
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
1answer
154 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
155 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 ...
2
votes
1answer
246 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 ...
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
150 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
100 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
198 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
418 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
91 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
219 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
948 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
109 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
3k 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 ...
1
vote
1answer
157 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 ...
0
votes
1answer
167 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 ...
3
votes
1answer
1k 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
975 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 ...
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
0answers
191 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 ...
0
votes
3answers
1k views

Setting up SQL Server service broker from one database to multiple databases

I would like to set a SQL broker service whereby DatabaseA sends the same data to DatabaseB and DatabaseC. In this case, all databases reside on the same instance. I have looked at the following ...
2
votes
1answer
3k 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 ...
3
votes
1answer
447 views

Is the Service Broker good for publishing data between servers?

I'm trying to find a better solution when publishing data to a remote table. So we have Server A and Server B. Server A holds a master table which should be replicated to Server B. Currently, we ...
0
votes
0answers
40 views

How can I use Query notification and what are the requirement? [duplicate]

I want to use Query notification in my app to get the notification from database for updated data, so that app will fire the query to get updated data instead of monitoring the database for every 5 ...
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: ...
5
votes
1answer
382 views

SA permissions issues with many nested objects

I have a broker application that's relatively complicated. Today, after I made some changes, I started getting the error: The server principal 'sa' is not able to access the database 'XYZ' under ...
6
votes
1answer
837 views

Recommendations on how to organize Queues in Service Broker

I have a service broker application that currently has 5 or 6 queues on two servers. The general workflow is: Server A User populates some tables User fires stored proc which puts a message into ...