Questions about service-broker
Read more about service-broker
python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
BEGIN DIALOG CONVERSATION returns NULL
I experienced an issue with the SQL Server service broker. If I quickly run several times a the script below.
BEGIN DIALOG CONVERSATION @DBHandle
FROM SERVICE A
TO SERVICE N'B'
ON CONTRACT CommandExec...
Daniele
Votes: 0
Answers: 0
SQL table queue - run procedure on data receipt
I'm optimizing a legacy application and only have access to the database, not the UI code.
There is a specific table insert occurring that I need to catch, so I can do some additional processing, but ...
CompanyDroneFromSector7G
Votes: 0
Answers: 0
Does SQL Server Broker require TRUSTWORTHY?
SQL Server >=2016
Do I need to set trustworthy on for database to run broker? Does it require this setting? Or it is possible somehow run Broker and do not set TRUSTWORTHY ON?
ZedZip
Votes: 0
Answers: 0
Is using table partitioning for maintenance on tables that the service broker writes to a good or bad idea?
We have an activated stored procedure that writes errors to a table, which I recently learned is 300GB. To get rid of the 300GB I'm going to save out recent data, then truncate/reseed the table durin...
mbourgon
Votes: 0
Answers: 0