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
73 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
264 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
277 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
112 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 ...
