python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - service-broker

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 ...
test-img

CompanyDroneFromSector7G

sql-server

triggers

queue

message-queue

service-broker

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?
test-img

ZedZip

sql-server

service-broker

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...
test-img

mbourgon

sql-server

service-broker

table-partitioning

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs