If I’m building a system that needs a full audit trail, what exactly am I gaining from your approach vs just doing insert-only rows with metadata (version, timestamp, user etc)? I mean, besides a nicer UI?
Also, when you say “immutable, off-host” — are we talking like another SQL Server instance on a diff machine? Or something else entirely?
And can this be queried directly with SQL too? Or is it locked behind some API/UI?
Also, when you say “immutable, off-host” — are we talking like another SQL Server instance on a diff machine? Or something else entirely?
And can this be queried directly with SQL too? Or is it locked behind some API/UI?