[freetds] implicit transactions
James K. Lowden
jklowden at freetds.org
Sun May 11 18:26:53 EDT 2008
James K. Lowden wrote:
> As Peter suggests,
>
> sp_configure 'user options', 0
>
> or, to turn off only implicit transactions,
>
> sp_configure 'user options', 4484
Peter also mentioned you need to execute the RECONFIGURE statement to put
the new "user options" in effect.
I should also correct myself: sp_configure sets server options, not
database options. (I'm not a DBA.)
You may also find this helpful to understand what's going on:
http://msdn.microsoft.com/en-us/library/aa196114(SQL.80).aspx
--jkl
More information about the FreeTDS
mailing list