Committing another users transaction

• Uncle Boris

  SSC Enthusiast

  Points: 191

  More actions

  June 9, 2008 at 3:36 pm

  #129397

  Hi, I think I know the answer to this but will ask it case I learn something new.

  A fellow DBA ran a delete statement with an explicit transaction.

  It took a while so he forgot about it and went home.

  I came in the next morning and jobs were backed up because of the block by the open transaction.

  I could kill the SPID but that would rollback the delete done the day before!

  I managed to call him and get him out of bed to commit it but what if this was not possible!

  Is there anyway I could COMMIT his transaction from outside his QA / SSMS window (we use SQL 2000 & SQL 2005)?

  Or is the only way getting his password, unlock his machine and commit?

  Thanks

• happycat59

  One Orange Chip

  Points: 29389

  More actions

  June 9, 2008 at 10:27 pm

  #826432

  I think you will need to get the password/unlock the workstation. SQL is not designed to allow someone else to take control of a connection.