Roll back

Question

Roll back

Lee From Bangalore

Right there with Babe

Points: 752
More actions
February 5, 2009 at 10:49 pm

#200896

Hi Buddy's
This is lee
1). I opend a newquery window
2). I updated one row
how to roll back it. Before that I didn't given begint tran.
Regards
lee

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

You can't. If you did not start an explicit transaction, then the changes were committed as soon as the statement completed and no rollback is possible

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

maechismo_8514 SSCoach Points: 17510 More actions · Answer 2

Did you just change one row? You are lucky, Just revert back the value.

You can restore the database to the earlier time but since its only one row, I would not be bothered

Mahesh Bote SSCrazy Eights Points: 9107 More actions · Answer 3

[font="Verdana"]

Lee From Bangalore (2/5/2009)
Hi Buddy's
This is lee
1). I opend a newquery window
2). I updated one row
how to roll back it. Before that I didn't given begint tran.
Regards
lee

Always follow:

Begin

Begin Transaction

Update / Delete / Insert Statement

If @@Error

Begin

RollBack Transaction

Error Handling

End

Commit Transaction

End

Mahesh

[/font]

MH-09-AM-8694

Vijaya Kadiyala SSCrazy Eights Points: 9119 More actions · Answer 4

Hi,

You need to Transaction Blocks to do it. By default if run any queries in Query Window , all of them are implicit commit.

You need to follow Mahesh's code to achieve.

Thanks

Vijaya Kadiyala

http://dotnetvj.blogspot.com

Thanks -- Vijaya Kadiyala
www.dotnetvj.com
SQL Server Articles For Beginers