The more I think about it, what kind of delay is acceptable in the reporting environment (C & D), relative to the live data on server A?   Any chance you...

I'm not sure I'd want to sign up for that scenario.   It sounds like you'll be managing it to death (your death, that is).   Starting to wonder if just restoring...

And as your error message refers to Procedure AuditView, you'll need to look there to find the source of the problem.

This post duplicates a problem previously posted, without referencing any of the previous material.  This forum doesn't generally like to have that happen, as it fragments the conversation and puts...

Just another go at this, which does 4 scans, but should produce accurate results:SET NOCOUNT ON;

CREATE TABLE #RELTEST (
  ID int NOT NULL PRIMARY KEY CLUSTERED,
 ...