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.
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 advisethanks |
|
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. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|