Tag: Auditing

Auditing Oddities – Why Would a Select Query Cause An Insert/Update/Delete Audit Record To Be Generated?

Quite the interesting problem was brought to me by a friend, in that they had a database level audit setup and were having `select` queries trigger audits that the object had updates run on them. The question became, how is this possible as a select query doesn’t update anything. Let’s start with a quick setup […]

Read article: Auditing Oddities – Why Would a Select Query Cause An Insert/Update/Delete Audit Record To Be Generated?

Auditing To the Security Event Log – SQL Server Error 33204 and OS Error 8

It’s Great When No One Asks Questions You’re taking the best steps to track what goes on in your instance – that’s awesome, even in heavily regulated industries which require these things, no one ever looks at them. Having been part of audits for years (and thankfully not involved for almost the last decade) I […]

Read article: Auditing To the Security Event Log – SQL Server Error 33204 and OS Error 8