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 2000 Forums
 SQL Server Development (2000)
 Rollback of UPDATE Statement

Author  Topic 

chocks
Starting Member

1 Post

Posted - 2003-11-17 : 10:15:17
Hi,

I executed the update statement in the production server database. How to execute rollback to get the original values.

Thanks in Advance,

Regards
Chockalingam

X002548
Not Just a Number

15586 Posts

Posted - 2003-11-17 : 10:21:43
ROLLBACK TRAN?


Oh, you didn't issue a BEGIN TRAN?

RESTORE?

No Dump?

INSERT INTO myTable (Col1, ect)
SELECT 'Data', ect UNION ALL
SELECT...

????


Something like that?

What did you do, Where did you do it...



Brett

8-)
Go to Top of Page
   

- Advertisement -