Results 1 to 2 of 2

Thread: simple rollback

  1. #1
    Join Date
    Mar 2010
    Posts
    3

    Unanswered: simple rollback

    I have used an update sql statement to change a table of sqlserver 2005 and I want to bring it back to its former state. can I rollback the table somehow?

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    By default SQL Server runs with implicit transactions. Unless you declare a transaction with BEGIN TRANSACTION, the update is automatically committed. If you did issue a BEGIN TRANSACTION before your update statement, you can issue a ROLLBACK TRANSACTION command, and the data will return to its original state. If not, then you will have to look at restoring the database to recover any lost data.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •