Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Tracking changes to a field in a table

Author  Topic 

avinashfj
Starting Member

2 Posts

Posted - 2006-09-04 : 01:43:34
Hi i would like to track changes to a particular field in a table in my sql server database....

I would like to know if there is any sql command that will let me see records that have that one particular field changed or modified ... can this be done using sql code and what code or function is available to do this ...

please advise

thanks

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2006-09-04 : 01:52:38
Not straight out of the box. You'll need to create some sort of audit table to hold this info.

You could possibly do this via transaction logs, but I'm not an expert on that particular area.
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-09-04 : 02:02:02
also see here for Audit Trail Trigger http://www.nigelrivett.net/SQLTriggers/AuditTrailTrigger.html


KH

Go to Top of Page
   

- Advertisement -