title: In SQL Server, how do I know what transaction mode I'm currently using?
body: <p>In SQL Server, how do I know what transaction mode I'm currently using? Such as <strong><em>autocommit, explicit, or implicit</em></strong>. And how can I change one mode to another using tsql?
  Great thanks.</p>