Skip to Content.
Sympa Menu

freetds - Re: [freetds] implicit transactions

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT freetds.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] implicit transactions
  • Date: Sun, 11 May 2008 18:26:53 -0400

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




Archive powered by MHonArc 2.6.24.

Top of Page