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 2005 Forums
 SQL Server Administration (2005)
 how to get the record i just updated by mistake

Author  Topic 

rtutus
Aged Yak Warrior

522 Posts

Posted - 2008-03-10 : 15:28:05
Hi,
I was opening a web page, that has a grid view representing the records of a table, I updated a record of the sql table by mistake, but I am not sure which record,
is there any way in Sql server to get the last record just updated few minutes ago. I hyave admin permissions on the DB.

Also, is there a way to know the value that was just there before the changes?

Thanks a lot.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-10 : 21:43:57
You can use third party tool like Lumigent's Log Exporlor to recover it.
Go to Top of Page
   

- Advertisement -