any way to undo processing?

[adrian]

Hi,

Is there any way to undo processing of a job other then using transaction?

actually i want something like the rollback feature of transaction but is there any other way to do it?

[skhanal]

Using BEGIN/COMMIT TRAN and ROLLBACK is the way to go.

If you don't want to use it you will have to write your own utility to back out any changes you make. You will have to audit all changes to do this.

Or if you are using ADO then you can do all the changes in disconnected recordset and after you are satisfied with the changes use update batch.

[adrian]

Thanks alot for the help

i tried implementing transaction but there seems to be some problems which i'm not if it's caused by transaction
but i doubt so.

the records are not sorted correctly, the date will be sorted something like 1,10,11...2,20,21 instead of 1,2,3..10,11...20,21

which i strongly believe that there is nothing to do with transaction.

i was told to remove the transaction and try to implement it another way.

Thanks again
adrian