A Simply way to implement Audit Trail in SQL 2005

In a recent project, I need to record audit trail for some tables (for Insert, Update and Delete).Using SQL 2005's XML datatype and the XML support it is very covenienet to use triggers to perform the audit trail requirement. I create one table (Table_Audit)  to hold all audit trial data. One stored procedure is created […]

5 (2)

2007-09-20

3,300 reads

Blogs

Career: Talk To References

By

As we try to get through these strange times in the world, I am...

This Saturday: #DataWeekender, DataSaturday Southwest

By

Geeked to be speaking 2x on Saturday May 14, my second time speaking at...

Daily Coping 14 May 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Why doesn't the Secondary failover?

By FrankFarquar

Hi, I hope someone can help. I will try to summarise as best as...

How to rewrite sql query after where condition with another query ?

By ahmed_elbarbary.2010

I work on sql server I need to rewrite statement after where statement so...

Incorrect syntax near the keyword 'AS'

By basmster

Hi Everyone. I'm hoping someone can take a look at my code here to...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Container Logs

See possible answers