A script to audit login and role member changes in SQL Server, tested end to end, including the failed attempts most people never think to capture.
SQL SERVER – Error 33222, Level 16 – Audit ‘MyAudit’ Failed to Start
Error 33222 says only that the audit failed to start. Reproduced on SQL Server 2025: where the real reason hides, and why CREATE succeeded.
Triggers That Assume One Row: Fixing Them for Multi-Row Updates
Fix triggers for multi-row updates by joining inserted and deleted, testing complete audit coverage, and keeping transaction work small.
SQL Server Audit: Tracking Who Read or Changed Sensitive Tables
Configure SQL Server Audit for reads and changes, inspect file records by user and time, and plan retention and target failures.
Who Changed This Row? Temporal History With FOR SYSTEM_TIME ALL
Read FOR SYSTEM_TIME ALL with LAG to compare row versions, choose temporal window boundaries, and record an actor when identity matters.
Who Changed This Row? Auditing Data Changes
Auditing data changes requires choosing whether you need old values, new values, actor identity, or a change feed, then testing the cost.
SQL SERVER – How to Chang Audit Location?
SQL Server auditing is a hidden gem. Learn how to change the audit location after it is created, for example when a network share fails.