.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Isolation Level set to Read Committed Snapshot, Deadlock Graph shows Read Committed

Posted By:      Posted Date: October 28, 2010    Points: 0   Category :Sql Server

I must misunderstand something here. I have altered the DB to allow READ_COMMITTED_SNAPSHOT and some deadlock situations have been solved. Nevertheless, in a very similar situation, I'm getting deadlocks and the deadlock graph (XML) shows me the following:

isolationlevel="read committed (2)"

What do I miss here?



View Complete Post

More Related Resource Links

Read Committed Snapshot vs Snapshot isolation


Hi all,

Can someone show me with an example what the difference betweent these two are?

please help me

What type of isolation is this "READ COMMITTED (2)"


I get below in Blocked Process Report. I understand READ COMMITTED, but what (2) signifies? Also why process status is listed as "suspended"?


 <process status="suspended" waittime="97" spid="55" sbid="0" ecid="0" priority="0" trancount="0" lastbatchstarted="2010-09-29T12:25:08.143" lastbatchcompleted="2010-09-29T12:25:08.023" clientapp="Internet Information Services" hostname="WEBAPP6" hostpid="2216" loginname="masteruser" isolationlevel="read committed (2)" xactid="735041142" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">

Isolation Level Read Uncommitted , Nolock & Replication



    Scenario : 

1. We have replication for Database D1.T1, D1.T2 , D1.T3
        Also have replication for Database D2.T1, D2.T2, D1.T3
2. We have view setup like
   Create View V1
   Select * from D1.T1
   Union All
   Select * from D2.T1

   Similarly V2 & V3
3.  We have Procedure using view V1, V2, V3

Fact. Set ISOLATION LEVEL READ UNCOMMITTED is always use inside the procedure

Question :

    1.  Procedure using Views V1 without NOLOCK on it (but have ISOLATION LEVEL UNCOMMITTED) , will that impact the replication on table T1, T2, T3  or Performance of the procedure or any Blocking?

   2. Procedure using Views V1 with Nolock on it (also have Isolation level Uncommitted) , Will that impact the replication on table T1, T2, T3 or performance of the procedure or any blocking?

3. Procedure using Views V1 with Nolock on it (Also have isolation level uncommitted) and
(Change my view as
  Create View V1
   Select * from D1.T1 With (nolock)
   Union All
   Select * from D2.T1 with (nolock)<

Merge Replication: How to give read access on snapshot share to a sql account

Hello All, I want to give read access to an sql account(not windows account). Can it be given or not. Someone please tell. Thanks saandii777

HyperLinkField Javascript DispEx: clicking link shows Read Only/Edit dialog


I have a web part that uses an SPGridView to display the documents that match previously selected criteria.

The user needs to see the 'Read Only / Edit' dialog that is displayed when a document is selected directly from the document library.

My research shows that I need to call the Javascript DispEx function somehow. How do I do this in the HyperLinkField setup? Can I somehow call it in the DataNavigateURLFormatString? This code is my latest attempt (which doesn't work). The 'onclick=' appears in the hyperlink.

 Dim hfTitle As New HyperLinkField()
            hfTitle.DataTextField = "name"
            hfTitle.DataNavigateUrlFields = URL
            hfTitle.DataNavigateUrlFormatString = _
"<a onclick=" & Chr(34) & "return DispEx(this,event,'TRUE','FALSE','FALSE','SharePoint.OpenDocuments.2','0','SharePoint.OpenDocuments','','','','1','1','0','0x7fffffffffffffff')" & _
Chr(34) & "href={0}"

            hfTitle.HeaderText = "Name"

Unable to read the security policy file for trust level 'WSS_Minimal' after editing 'Alternate Ac



This is my first post, so I hope that I have picked the correct forum - it seemed the most appropriate.
I am pretty green when it comes to SharePoint admin, but as it was going so well I got a bit over-confident and tried out the 'Alternate Access Mapping'.  I didn't intend to save any changes, but I must have, because now under:

Central Administration > Operations > Alternate Access Mappings >
Edit Public Zone URLs

the 'Default' is "http://<myServer> : <port>"

and afaik there was no setting there before.  Unfortunately, I can no longer connect to http://myServer : port, although I can connect to the 'Central Administration' site on http://myServer : otherPort.  Apologies in advance for the data dump below, but if anyone has any suggestions on what I could've done (or even better what I could do to fix it before tomorrow :-) I would be very grateful.

Here are the errors that I saw/see in the browser:

Is Dirty Read Isolation the only option to import data from informix using SSIS consistently


Hi there

I've got a package that imports data from informix database. I'm using iBM Informix ODBC Driver 3.50 with ADO.NET data source to import data. Every now and then the package fails with "Could not do physical order read to fetch next row" issue so did some investigation and found that its due to the lock issue. Most of the guys suggested setting up isolation level to "Dirty Read".

Is it the only option to import data consistenly without any error from Informix? Because with "Dirty Read" you get concurrency issue. 

My other question is; can we use the transaction option with isolation level available is SSIS to get around this issue and if yes then how to approach it. And if it's no then is it limited to oledb sources only.


Regards, Vivek

Serial Port Communication Read and Write using C#.net

In this simple article you will learn that how you can Open and read COM port data using System.IO.Ports Namespace.
Simply just create New Project of windows application in C#.

Import ServiceProcess APIs
using System.IO.Ports

Imports System.IO.Ports

Write Parsing functions which parse port data according to attached device

Scripts not read when in head tag


I just upgraded to VS2010 if that matters.  I'm learning JQuery and noticed that scripts don't work if they're in the head tag.  Also, I need the script tag with type="text/javascript" in the head (with nothing else) in order for the JQuery scripts in the body to work.

Very bizzare, any suggestions?

With a separate script tag in the <body> with my JQuery script, this works

<head runat="server">
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js" />
<script type="text/javascript">

This doesn't:

<head runat="server">
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js" />

I am not able to read xml file with XDocument if its Descendants has Attribute xmlns="http://abc.co


I am not able to read xml file with XDocument if its Descendants has  Attribute like:-

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
  <row ID="1" xmlns="http://www.opentravela.org/OTA/2003/05">
    <var country_name="Caribbean and Rest of the world" city_name="Kingston" flight_category="Economy Class" via="Atlanta" flight_departure="London Heathrow" airline_logo="Delta" adult_fare="Delta" child_fare="660" infant_fare="561" date1="132" date2="2010-08-15" />


I don't know what to do ?

Looking for some help..

How to read XML using LINQ in VB.NET


Can someone please tell me (sample code) how to read this XML into a SQL DB?  Should I use LINQ to XML?  Does anyone have any sample code?  I am working in VB.NET


<?xml version="1.0" encoding="utf-8"?>

<ReadOrderResponseType xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<Status xmlns="urn:mysol:apis">Success</Status>

<TimeStamp xmlns="urn:mysol:apis">2010-07-25T15:26:49.1150235Z</TimeStamp>

<StoreUrl xmlns="urn:mysol:apis">http://xyz.COM</StoreUrl>

<PageResponse xmlns="urn:mysol:apis">




Read Excel file from Web Application (C#)



I have a web app where user uploads a file.

File is saved in server locally and I want to read some data from it.

Currently my development  server has office 2003.

So do I need office 2007 in order to be able to  read an excel from office 2007 ?

What are other requirements  ?

I tried a test, using

Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook wrkBook; // = new Microsoft.Office.Interop.Excel.Workbook();

wrkBook = excelApp.Workbooks.Open(@"C:\www\excel_files\b.xls", ....);

But When trying to open the file I get the error:

Exception from HRESULT: 0x800A03EC

So I'm wondering what I'm missing.


How to read value of CheckBox in EXCEL sheet


I am using OLEDBConnection (@"Provider=Microsoft.ACE.OLEDB.12.0;") to connect to the EXCEL file and read contents. When I read the contents, I get all the contents from the excel sheet but i dont get contents for checkboxes placed inside.

My Excel sheet contains set of checkboxes and I need to know If they are checked or not.These checkboxes are controls which are added from Developer tab in EXCEL.

I dont want to use Excel Assemblies for reading contents as it is not recommended. And also i am using OLEDBconnection and want to stick to this .

Awaiting replies from you guys. Thanks in Advance.

How to read Excel table?


If I  use Microsoft.Jet.OLEDB.4.0 to retreive for example named range or sheet from Excel and use it as data source for some server control on the ASP page, everything works fine. But when I try to get table from Excel like this: "select * from [Table1]", debugger complains that database engine could not find object Table1. So how should I reference Table1 in Excel file so that the database engine could find it?

How to read the custom http header



I have just joined the forum. I have a very simple query. I have added custom header to my website. Now I want to read the custom header. I am using IIS 6.0 on windows XP. I have already tried using using the Request.ServerVariables and and Request.header method. But none of them give me the custom header added to website.

Can any body help?

Thanks a lot in advance



Can't read global resource in asp button


I have translated Text Ok in arabic and I have that placed in global Navig.resx file

<asp:Button ID

Crystal Report gives System.AccessViolationException: Attempted to read or write protected memory. T


when a crystal report for same id is opened again at same time or refreshed then it gives the

"System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt."

Stack Trace is :-

Stack Trace:

[AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.]
CrystalDecisions.ReportAppServer.Controllers.DatabaseControllerClass.SetConnectionInfos(ConnectionInfos ConnectionInfos) +0
CrystalDecisions.CrystalReports.Engine.Table.ApplyLogOnInfo(TableLogOnInfo logonInfo) +362
CrystalDecisions.CrystalReports.Engine.ReportDocument.SetTableLogon(Tables tables, String user, String password, String server, String database, Boolean ignoreCase) +258
CrystalDecisions.CrystalReports.Engine.ReportDocument.SetDatabaseLogon(String user, String password, String server, String database, Boolean ignoreCase) +204
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend