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

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)

Auto Auditing on Tables

By Christopher Stobbs,

This is something that I find very useful and saves me a lot of time.

This procedure needs to be created on the Database that holds the table that you wish to Audit. This procedure when called will create an audit table based on your source table in a database of your choice. All update/delete and insert triggers will also be created.

The results are then printed out so that you can make an small modifications that you may need to.

Total article views: 9015 | Views in the last 30 days: 47
 
Related Articles
FORUM

Creating PK

Creating PK

FORUM

creating filegroup

creating filegroup

FORUM

create function

create function

FORUM

Create Permission in Schema

Create Permission

FORUM

can't create user

create user

 
Contribute