how to roll back

From: pk (pk_at_)
Date: 03/29/04 

Date: Mon, 29 Mar 2004 11:05:00 +0800

is this the only way to do a rollback in SQL2000 ?

Use Query Analyzer, BEGIN TRAN ...... COMMIT TRAN, then ROLLBACK TRAN to
undo the changes. And only applicable for UPDATE & DELETE queries within the
transaction.

just want to understand more how to use rollback and how it works.

tks
pk

Relevant Pages

  • Re: sql question
    ... > begin tran ... > together to enable the rollback if the data being changed it not ... command to SQL Server and then commit or rollback as needed. ... In the first batch, you issue a BEGIN ...
    (microsoft.public.sqlserver.programming)
  • RE: Transaction ROLLBACK Errors...
    ... "Mark Essex" wrote: ... > rollback tran ... > The rollback works correctly, in that all information is rolled back, ...
    (microsoft.public.sqlserver.programming)
  • Re: DBD::Sybase and auto commit
    ... >> rollbacks into the stored proc. ... >> EXECUTE indicates that a COMMIT or ROLLBACK TRAN is missing. ...
    (perl.dbi.users)
  • Re: ROLLBACK TRAN / TRIGGER
    ... you do not need to start a transaction using Begin Tran but can ... issue a Rollback Tran as Begin Transaction is implicit and SQL Server starts ... Therefore, issue a ROLLBACK ... The Sybase Triggers had ROLLBACK TRIGGER statements, ...
    (microsoft.public.sqlserver.programming)
  • Transaction ROLLBACK Errors...
    ... Another thing you can do is put the begin/commit tran in ... If you want to save someting in SP2 or SP3 you can create ... will allow you to rollback to SP3.savepoint, ...
    (microsoft.public.sqlserver.programming)
Quantcast