Auditing

External Article

Designing Tables for Audit Data in SQL Server

  • Article

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?

2008-04-15

5,915 reads

SQLServerCentral Article

Monitoring and Recording DDL changes on SQL 2005 (NARC)

  • Article

Auditing activities on your database servers becomes more important all the time. But ensuring that schema changes do not occur without your knowledge may be more important for a stable system. James Greaves brings us a great technique using DDL triggers for doing this.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.52 (21)

You rated this post out of 5. Change rating

2008-02-29

7,361 reads

Blogs

Not Selected for the PASS Data Community Summit 2024

By

I got this in an email about a week ago from the PASS Data...

A New Word: Addleworth

By

addleworth – adj. unable to settle the question of whether you’re doing okay in...

Data Technology Learning Resources

By

Hey all! Quick one here. Tracy Boggiano, awesome person that she is, has put...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers