Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts with tag Auditing Rss

Search for any content tagged auditing

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 20 of 20   

Change Login Auditing Option

Configure Login Auditing  
By ESAT ERKEC 2016/11/14 | Source: | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 242 reads

Failed and Successful Login Auditing Using xp_readerrorlog

Script uses undocumented extended stored procedure xp_readerrorlog to find failed logins (grouped) and last successful login  Read more...
By Ryan Loftin 2015/12/30 | Source: | Category: auditing
Rating: |  Discuss |   Briefcase | 908 reads

Users , Roles and Logins

Useful script in cases where auditors would like to know roles for each user in each database of an instance as well as the status of associated logins.  Read more...
By Kenneth Igiri 2015/02/03 | Source: | Category: auditing
Rating: |  Discuss |   Briefcase | 2,642 reads

Last Accessed Datetime for table - Easiest way

This function is used to get the complete table lists are particular table and its last access datetime.  Read more...
By Vignesh Arulmani 2016/03/07 | Source: | Category: auditing
Rating: |  Discuss |   Briefcase | 3,061 reads

Security Queries: Database-level

A set of queries which attempt to gather as much security-related information on a single database as possible.  Read more...
By Greg Drake 2015/10/30 | Source: | Category: secure
Rating: |  Discuss |   Briefcase | 3,307 reads

Security Queries: Server-level

A set of queries which attempt to gather as much security-related information on a server instance as possible.  Read more...
By Greg Drake 2013/11/05 | Source: | Category: secure
Rating: |  Discuss |   Briefcase | 1,858 reads

iSpy (on your development)

Using EventNotification (Service Broker - DDL_EVENTS) to audit Schema change on a Server, or any of it's databases  Read more...
By Rob Lobbe 2013/06/19 | Source: | Category: schemas
Rating: |  Discuss |   Briefcase | 1,415 reads

Server-Side Trace Pack

Loads temporary stored procs that assist in running and monitoring server-side tracing.  Read more...
By Greg Drake 2012/03/02 | Source: | Category: server side trace
Rating: (not yet rated) |  Discuss |   Briefcase | 1,032 reads

Audit All Permissions

This script will return all permissions on the server.  Read more...
By Jim Sebastiano 2011/11/16 | Source: | Category: permission
Rating: |  Discuss |   Briefcase | 3,631 reads

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

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...
By Gokhan Varol 2011/06/20 | Source: | Category: cdc
Rating: |  Discuss |   Briefcase | 674 reads

Track changes of a table vaules in Sql 2008

Track any changes made to the rows of the table using single stored procedure  Read more...
By shivam.shah 2011/05/26 | Source: | Category: auditing
Rating: |  Discuss |   Briefcase | 2,050 reads

Windows Group Membership Checker

A script to reveal which logins have access to your sql server via windows groups.   Read more...
By Richard Doering 2010/09/01 | Source: | Category: security
Rating: |  Discuss |   Briefcase | 2,100 reads

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

This script will help the developers in multi-user environment to check if anyone else modified their tables, view, procedures etc..  Read more...
By Chrysanthemum 2010/11/10 | Source: | Category: auditing
Rating: |  Discuss |   Briefcase | 5,316 reads

Default Trace Load of All 5 Files

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.  Read more...
By Lowell Izaguirre 2009/02/25 | Source: | Category: sql trace
Rating: |  Discuss |   Briefcase | 1,194 reads

DDL Triggers Implementation

How to use DDL triggers and Query the Data with minimum performance impact.  Read more...
By Jorge Novo-@ETLDEVDBA 2008/10/02 | Source: | Category: ddl triggers
Rating: |  Discuss |   Briefcase | 1,783 reads

Who has accessed my 2005 server?

Find out who has been on my server using the Default trace.  Read more...
By Jack Corbett 2013/04/02 | Source: | Category: auditing
Rating: |  Discuss |   Briefcase | 15,089 reads

List all Usernames, Roles for all the databases.

Generates a list of ALL Users and their database Roles for all Databases (Or for a specific user).  Read more...
By Shivaram Challa 2013/12/30 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 22,065 reads

Script Generates Audit Triggers

This script generates a audit trigger for each table in the database. The trigger then logs when each table is updated.  Read more...
By Farrell Thomas 2011/11/23 | Source: | Category: triggers
Rating: |  Discuss |   Briefcase | 4,485 reads

Table journal

Create journal to audit changes in user table 
By Boka 2007/12/12 | Category: journal
Rating: |  Discuss |   Briefcase | 1,713 reads

Audit SQL Logins - Updated

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...
By Derrick H. 2011/05/23 | Source: | Category: auditing
Rating: |  Discuss |   Briefcase | 13,020 reads
   Items 1 to 20 of 20