Question : I’m trying to find a better solution when publishing data to a remote table. So we have Server […]
Tag: service-broker
Does setting a database to single_user prevent delivery of Service Broker messages?
Question : Is it safe to assume that while a database is in single_user mode, the queues are not available […]
Using Service Broker internal to a single SQL Express instance?
Question : I understand that SQL Express cannot send Service Broker messages to other instances without a Standard (or better) […]
sqlpackage.exe fails on SignalR objects
Question : Issue: When running sqlpackage.exe to apply a sql dacpac, it occasionally fails on broker/SignalR related objects, which breaks […]
What are the requirements to installing Sql Server Service Broker External Activator on a remote machine?
Question : I have implemented Service Broker on one of my databases, and have successfully processed messages with my own […]
Does firing off an indefinite WAITFOR increase the log file size?
Question : In the last release of my app, I added a command that tells it to wait when something […]
Monitor For Disabled Queue On RDS SQL Server
Question : I would like to somehow get notification of a queue being disabled due to poisoned messages. (The issue […]
How to run Sql Server stored procedure in Async mode?
Question : Is there a way to run SQL Server 2019 stored procedures with parameters asynchronously? Calls to this SP […]
Service broker was backed up, now receiving, but doesn’t seem to be processing
Question : Having a problem with Event Notifications. On the machine/drive/database that the messages are sent to (receiver), the drive […]
Take action from extended event?
Question : I’ve seen it mentioned a few times that you can configure an event session to take an action […]