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 2008 Forums
 SQL Server Administration (2008)
 Record modification time

Author  Topic 

Yassine1985
Starting Member

1 Post

Posted - 2013-01-21 : 07:40:36
Hello,

I know it is been widely discussed over the net, but i could not find any clear answer.

Is there any possibility to GET the modification date of a record in a table, knowing i don't use a timestamp column of course.

the thing is we have and old record that should have been modified but now we have serious problems because we found an old value in this field , one of our colleague is sure that he have done this modification.

also our oldest backup is only 1 month ago :( .

Thanks very much for your help

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-01-21 : 09:27:47
Unless you had some something like CDC or other type of auditing enabled, I know of no way to retroactively find the change history.
Go to Top of Page
   

- Advertisement -