Solved

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

Posted on 2012-04-02
3
453 Views
Last Modified: 2012-04-24
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
Comment
Question by:mmingfeilam
  • 2
3 Comments
 
LVL 19

Expert Comment

by:Rimvis
Comment Utility
Hi mmingfeilam,

Did you check application name for this connection? Is it SSMS or your C# application?
0
 

Author Comment

by:mmingfeilam
Comment Utility
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
 
LVL 19

Accepted Solution

by:
Rimvis earned 500 total points
Comment Utility
Not really. Can you add ApplicationName to the profiler trace?
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now