Transaction modes

• cdun2

  SSCertifiable

  Points: 7893

  More actions

  May 2, 2003 at 4:16 pm

  #158885

  Hello,

  Could someone please explain to me the difference between 'Autocommit Mode' and 'Implicit Transaction Mode' in SQL Server 2000, and maybe provide an example or two?

  Thanks for your help!

  CSDunn

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  May 2, 2003 at 6:14 pm

  #456085

  See "Autocommit Transactions", "Implicit Transactions" and "SET IMPLICIT_TRANSACTIONS" for explaination and examples in BOL