txn isolation level and connection pooling -- sql server connect

Vikram Vamshi
6/6/2006 11:55:02 AM

Hi All,
Should the transaction isolation level persist across the reuse of a
connection from the connection pool?

From my experiment it does persist and I was not expecting it.
I was under the impression that "sp_reset_connection" will tear down all the
connection level settings and go back to the defaults before a connection is
reused.

I am using the sql .net provder with the 1.1 framework and connecting to a
sql 200 server.

Just wondering if this is a bug or by design ...

--
Vikram Vamshi
Database Engineer
Eclipsys Corporation

PS: I have cross posted in dotnet.framework.adonet group too

Andrew J. Kelly
6/6/2006 10:28:10 PM

What isolation level where you going from and to? can you give details on
exactly how you tested this?

--
Andrew J. Kelly SQL MVP

[quoted text, click to view]

sql server connect : txn isolation level and connection pooling