freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: "Federico Alves" <sales AT minixel.com>
- To: <freetds AT lists.ibiblio.org>
- Subject: Re: [freetds] FreeTDS Digest, Vol 64, Issue 12
- Date: Sat, 10 May 2008 02:04:53 -0400
I thought it was my application, but from this machine, even TSQL opens the
connection like this:
- network protocol: TCP/IP
set quoted_identifier on
set arithabort off
set numeric_roundabort off
set ansi_warnings off
set ansi_padding off
set ansi_nulls off
set concat_null_yields_null on
set cursor_close_on_commit on
set implicit_transactions on
set language us_english
set dateformat mdy
set datefirst 7
set transaction isolation level read committed
Microsoft determined that the problem that brought SQL Server down was
"set implicit_transactions on" What causes the change in behavior? Microsoft
thinks that this should be off, otherwise every transaction must be
committed explicitly in code. How do I turn this feature off?
Federico
-
Re: [freetds] FreeTDS Digest, Vol 64, Issue 12,
Federico Alves, 05/10/2008
- Re: [freetds] FreeTDS Digest, Vol 64, Issue 12, James K. Lowden, 05/10/2008
Archive powered by MHonArc 2.6.24.