Home Forums SQL Server 2008 SQL Server 2008 Administration Safe Triggers on Production ? RE: Safe Triggers on Production ?
Ken McKelvey
SSCoach
Points: 18755
More actions
October 25, 2016 at 10:02 am
#1908670
You could look at creating asynchronous triggers with service broker. This would stop the summary table from interfering with production DB.
The downside is the plumbing and having to monitor service broker.