PROD Delete issue

• scranthdaddy

  Mr or Mrs. 500

  Points: 552

  More actions

  April 16, 2003 at 10:12 am

  #81423

  Hi, if I accidentally executed a statement:

  Delete from tblComp

  on a huge table through QA, and QA never responded with 'x rows(s) affected', do any rows actually get deleted, even though it never produced a response?

  Or would those first seconds I waited have all the changes rolled back?

  Please tell me they get rolled back..

  Thanks.

  Andrew J. Hahn

  
  Andrew J. Hahn

• Rajesh Patavardhan

  SSCrazy

  Points: 2801

  More actions

  April 16, 2003 at 10:29 am

  #454399

  The easiest way to verify this is do a select on this table. if rows exists then you are safe. The Query is rolled back.

  Sql server works on implicit transaction mode by default.

  By default this will be on. When this is on sql*server starts a new transaction automatically when DELETE command is executed.

  Hence it either deletes all rows or rollsback everthing deleted by this statement.

• scranthdaddy

  Mr or Mrs. 500

  Points: 552

  More actions

  April 16, 2003 at 10:37 am

  #454402

  The table still contains thousands of records, but I just wanted to know if part of those records could have been deleted. From what you've said, its an all or none type of transaction.

  Whew!

  Thanks for your help.

  Andrew J. Hahn

  
  Andrew J. Hahn