i am running sql profiler and been getting this message frequently:
-- network protocol: TCP/IP set quoted_identifier on set arithabort off 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
the problem is that in my c# code i have set all TransactionScope IsolationLevel to ReadCommitted. so either i missed to set everything to ReadCommitted in my code, or SQL Management Studio is doing something outside of my code. thanks.