<div>
There are not &quot;advantages&quot; or disadvantages as such. The difference is for your convenience or security.<br />
-&gt; Set it on mean that you need explicitely use commit to save the last statements to the database. This means you can rollback after you saw the flaw in your code (before issuing the commit)<br />
-&gt; Set it off means that each statement is automatically committed. this can be &quot;dangereous&quot; (see above)
</div>


There are not "advantages" or disadvantages as such. The difference is for your convenience or security.
-> Set it on mean that you need explicitely use commit to save the last statements to the database. This means you can rollback after you saw the flaw in your code (before issuing the commit)
-> Set it off means that each statement is automatically committed. this can be "dangereous" (see above)

<div>
nigelrivett,<br />
Is there any strong reason why you recommend that
</div>


nigelrivett,
Is there any strong reason why you recommend that

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Can anybody help me in understanding the advantages &nbsp;and disadvantages<br />
of setting the implicit_transactions on or off<br />
<br />
thanks,
</div>
</div>


Hi,

Can anybody help me in understanding the advantages  and disadvantages
of setting the implicit_transactions on or off

thanks,

Regarding set implicit_transactions on

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.