Posted by Jens on 10/02/32 11:45

If you don´t have a transaction scope defined around the command:

BEGIN TRANSACTOON
DELETE FROM SomeTable
ROLLBACK --THis does a rollback

...you can´t. You will need to restore your data from a backup.

HTH, jens Suessmeyer.

---
http://www.sqlserver2005.de
---

• Next in forum: Re: Sum Accumulating Data
• Prev in forum: Re: Sum Accumulating Data
• Thread view: Re: Undo last statement

[Reply to this message]