Results 1 to 2 of 2

Thread: Begin Trans

  1. #1
    Join Date
    Oct 2004

    Unanswered: Begin Trans

    If you are set up for AutoCommit why would you or should you set a explicit transaction? I have noticed that in some called stored procudures from a "container" stored procedure. (Hope I got that right) that in the called stored procedure a Begin tran is used. Can anyone help with the why and what fors? It seems to me that you want to let SQL Server handle this becuase of the danger of leaving out a Commit or Rollback? But thats me. I may be very wrong? Thanks.


  2. #2
    Join Date
    Nov 2002
    Well....there's a lot of reading you can do in books online....BUT, just as a good general coding practice you should...

    I like to follow this template...I'd say most of my sprocs are this 90%

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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