Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Database Design, Auditing Rss

   Items 1 to 1 of 1   
 

Designing Tables for Audit Data in SQL Server

My company is just starting to look at adding functionality to retain historical data for key tables and columns for auditing purposes in many of our SQL Server databases. I have seen some of your recent tips related to triggers (Forcing Trigger Firing Order in SQL Server and Trigger Alternatives in SQL Server - OUTPUT Clause). Based on using triggers or a similar technology, what is the best way to store the historical data?  Read more...
By Additional Articles 2008/04/15 | Source: MSSQLTips.com | Category: auditing
Rating: (not yet rated)  Rate this |   Briefcase | 5,300 reads
   Items 1 to 1 of 1