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 |
|
dnf999
Constraint Violating Yak Guru
253 Posts |
 Posted - 2008-11-03 : 08:31:12
|
| Hi I need to find out what time/date fields were updated in my SQL database. Please let me know if there is way I can do this, either through Enterprise manager or T-SQL.I would appreciate if you could let me konw the methods in both SQL Server 2000 and SQL Server 2005.Many Thanks!! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-03 : 09:21:14
|
| you mean trace which of records where updated in a particular day by looking into date fields? then what you could do is to check for records with date value equal to current days date. |
 |
|
|
dnf999
Constraint Violating Yak Guru
253 Posts |
Posted - 2008-11-03 : 10:16:59
|
| What I mean is, if a user updated a particular field after the record was created. Would that be possible? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-03 : 10:22:14
|
| the best way to do is to have an audit column to track modifications with default set to current date. this will enable to identify any records that were modified on particular day by comparing datemodoified fields value with current date. |
|
|
|
|
|
|
Trace time/date field updated