OmniAudit automatically and transparently tracks changes to data in any column of any table in your Microsoft SQL Server 7.0 or 2000 databases. OmniAudit generates triggers to create audit trail data for the tables and columns you select.
Apex SQL Log is a powerful SQL database auditing and recovery tool that analyzes SQL Server's own Transaction Log to display information on data changes