|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
txn isolation levelHi,
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. 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 |
|||||||||||||||||||||||