This script generates a audit trigger for each table in the database. The trigger then logs when each table is updated.  Read more...

This script will return all permissions on the server.  Read more...

CDC provides before and after images of modified data. If information about the session required that modified the cdc there is a workaround.  Read more...

SQL Auditing - Generate a listing of the SQL logins, and the permissions for each database on a server. Update to Simon Facer's script.   Read more...

A script to reveal which logins have access to your sql server via windows groups.   Read more...

Complete package to allow tracking of any data that Profiler can capture and storage for auditing purposes, use to satisfy SOX compliance.  Read more...

Filtering DML statements by loginname , host name or application name   Read more...

In this article, Johan Bijnens shows how logon triggers can bite you in the back.  Read more...

This Article shows a method to audit ETL-Processes to be able to retrace processes and affected data.  Read more...

Generates a list of ALL Users and their database Roles for all Databases (Or for a specific user).  Read more...

This script generates a audit trigger for each table in the database. The trigger then logs when each table is updated.  Read more...

Create journal to audit changes in user table  Read more...

SQL Auditing - Generate a listing of the SQL logins, and the permissions for each database on a server. Update to Simon Facer's script.   Read more...