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,289 reads

Blogs

What the ???? T-SQL Tuesday #120

By

Hey, it’s T-SQL Tuesday again! I almost forgot about it what with Summit and...

First Time Speaking at PASS Summit

By

This week, I filmed my experience as a first time speaker at PASS Summit...

Azure SQL Best Practices?

By

A way to enforce good practice and standards is by Azure Policy. As stated...

Read the latest Blogs

Forums

SQL View - Pivot

By bbranco

I have the following data in a table, its pricing for items, so if...

does WITH (NOLOCK) hint in Select statement really make a difference?

By VoldemarG

In any regular Select query joining a few tables like below, does using this...

Query

By jsshivalik

Hi Table 1 AccountId Name 1101 aaaa 1701 bbbb Table 2 TransId Account Debit...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers