SQLServerCentral.com Scripts tagged Auditing

Server-Side Trace Pack

Fri, 02 Mar 2012 07:00:00 UT

Loads temporary stored procs that assist in running and monitoring server-side tracing.

Audit All Permissions

Wed, 16 Nov 2011 07:00:00 UT

This script will return all permissions on the server.

Link Session info to CDC or in other words Auditing with CDC

Mon, 20 Jun 2011 06:00:00 UT

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

Track changes of a table vaules in Sql 2008

Thu, 26 May 2011 06:00:00 UT

Track any changes made to the rows of the table using single stored procedure

Windows Group Membership Checker

Wed, 01 Sep 2010 06:00:00 UT

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

SQL Script to check what was changed in database after 9PM Last night

Wed, 10 Nov 2010 07:00:00 UT

This script will help the developers in multi-user environment to check if anyone else modified their tables, view, procedures etc..

Default Trace Load of All 5 Files

Wed, 25 Feb 2009 07:00:00 UT

The default trace keeps the last 20 meg of info, and a max of 5 files...This loads all 5 files into a table so it can be reviewed.

DDL Triggers Implementation

Thu, 02 Oct 2008 14:05:16 UT

How to use DDL triggers and Query the Data with minimum performance impact.

12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.

Who has accessed my 2005 server?

Tue, 02 Apr 2013 06:00:00 UT

Find out who has been on my server using the Default trace.

List all Usernames, Roles for all the databases.

Mon, 31 Dec 2012 07:00:00 UT

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

Script Generates Audit Triggers

Wed, 23 Nov 2011 07:00:00 UT

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

Table journal

Wed, 12 Dec 2007 07:00:00 UT

Create journal to audit changes in user table

Audit SQL Logins - Updated

Mon, 23 May 2011 06:00:00 UT

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