Audit Trail in SQL Server 2000 or SQL Server 7

This is an article on Audit Trail in SQL Server 2000 or SQL Server 7 in SQL Server.

Rated 5.00 By 1 users

There are many occasions where if someone updates a records or even deletes a record we need to keep the Audit trails of the record updated or deleted or even keep a history of records as what are the updates that happened on the database as well as what are the records deleted from the table. In Any database system there are triggers to achieve the same but remember that if triggers if not used efficiently can degrade the performance of the Database system