SQLTeam.com | Weblogs | Forums

MS SQL 2000 enterprise server and row date and time


#1

Dear netizen

we need some help to find out the date and time a row changed in a table.

Please advise if this is possible. We are currently using MS SQL 2000 Enterprise. Transaction log is set to simple.

Any help is much appreciated. Many thanks in advanced!

best regards, Jessica
jesskung88@gmail.com


#2

There is no simple way to do this if at all.
The best you can do is create a tracking process for the future.


#3

Extended support for SQL Server 2000 ended on April 9, 2013. You are really quite out of luck (and out of time!)