My application is calling multiple SPs it seems like between these calls the isolation level is being changed to Serializable. I have went through the code and we are not setting the isolation level anywhere. Is it possible to know if SQL connection pool is setting this level?
I am using MS SQL 2008 R2.
When I run SQL profiler, I see that the isolation has changed. The SP called is not changing it. Is it that since the isolation level is not specified, SQL connection pool is deciding which level to use and not setting it back?
Audit Login -- network protocol: LPC
set quoted_identifier on
set arithabort on
set numeric_roundabort off
set ansi_warnings on
set ansi_padding on
set ansi_nulls on
set concat_null_yields_null on
set cursor_close_on_commit off
set implicit_transactions off
set language us_english
set dateformat mdy
set datefirst 7
set transaction isolation level serializable
Reused pooled connections do not change the transaction isolation level.
Perhaps you are using TransactionScope. The default isolation level with TransactionScope is serializable unless you specify otherwise.