provides the infrastructure for queue-based asynchronous message communication between databases.
5
votes
1answer
77 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 ...
2
votes
1answer
76 views
Service Broker stops working
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
0answers
343 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
0answers
128 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
267 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 ...
1
vote
0answers
278 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
5 views
How can I use Query notification and what are the requirement?
I want to use Query notification in our app to get the notification from database for updated data, so that app fire the query to get updated data instead of monitoring the database for every 5 sec. I ...
0
votes
0answers
116 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 ...
0
votes
0answers
31 views
How to bind contract to service?
I have a service broker setup where server A is updating server C with no problem. I now need to add another service broker setup where server B also updates the same database on server C.
When I ...
0
votes
0answers
18 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 ...
0
votes
0answers
117 views
In SSB, how would you implement external activation to a particular (1) user when you only have one initiator queue and one target queue?
On a database which has multiple user application instances en-queuing messages to one initiator queue sending messages to a target queue which activates a server application, I am revising the ...
