Begin Transaction

• Slick84

  SSCertifiable

  Points: 5602

  More actions

  July 14, 2009 at 2:13 pm

  #208339

  Hi,

  I want to know how long does it take for the "Begin Transaction" in SQL Server 2005 to time out?

  I was doing some testing of my stored procedure and thought I would use a transaction block. I "began" my transaction by using the BEGIN TRANSACTION but forgot to "ROLLBACK TRANSACTION" as I did not want to commit it.

  So anyway, when I remember, I went back to roll it back, but it gave me the below error:

  Msg 3903, Level 16, State 1, Line 1

  The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.

  Thanks,

  S

  --
  :hehe:

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  July 14, 2009 at 2:21 pm

  #1024708

  Slick84 (7/14/2009)

  ---

  Hi,

  I want to know how long does it take for the "Begin Transaction" in SQL Server 2005 to time out?

  It doesn't timeout. If you start a transaction and don't commit it, it will remain active until that connection is closed or the server is restarted,

  So anyway, when I remember, I went back to roll it back, but it gave me the below error:

  Msg 3903, Level 16, State 1, Line 1

  The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.

  Did you do the rollback in the same connection as the begin?

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Slick84

  SSCertifiable

  Points: 5602

  More actions

  July 14, 2009 at 2:31 pm

  #1024713

  I believe so as I dont have any other connections open.

  Maybe I rolled it back and don't remember that I did. Confused now. Anyhow......... Thanks for that information, its always good to know that it will not timeout 😀

  --
  :hehe: