• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 501
  • Last Modified:

what does "set transaction isolation level serializable" message mean?

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.
0
mmingfeilam
Asked:
mmingfeilam
  • 2
1 Solution
 
RimvisCommented:
Hi mmingfeilam,

Did you check application name for this connection? Is it SSMS or your C# application?
0
 
mmingfeilamAuthor Commented:
application name is not one of the params being returned by the sql profiler template, it has:

[EventClass]
      ,[TextData]
      ,[CPU]
      ,[Reads]
      ,[Writes]
      ,[Duration]
      ,[ClientProcessID]
      ,[SPID]
      ,[StartTime]
      ,[EndTime]
      ,[EventSequence]
      ,[TransactionID]
      ,[DatabaseName]
      ,[NTDomainName]
      ,[EventSubClass]
      ,[ObjectName]
      ,[BinaryData]

does any of them help?
0
 
RimvisCommented:
Not really. Can you add ApplicationName to the profiler trace?
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now