Re: FreeTDS Digest, Vol 64, Issue 12
"Federico Alves" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <00b001c8b263$c4548900$4cfd9b00$@com> |
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