HI Satya and MeanoldDBA, I need help regarding how to overcome dead lock situaton, as i am very careful doing any change on the live server, as its...
Hi All, Thank you for u people guidance. I will ask any question, if feel any problem, finding out the deadlock cuplprit. Regards, Adnan
Hi Satya, Thank you for guiding me for this direction. I found the processid but dont understand how its blocking in irregular period of time, like...
Hi Satya and MeanOldDBA, I am not using any SQL Server transaction on the live site and we have only one application that is calling DataBase Server....
Hi All, Here are my answers of those questions that you people have asked. In my DAL, transaction facility is there, but i am not using transaction...
Satya,<br />please have a look at my DAL layer which is calling Stored procedures.<br /><br />Imports System<br />Imports System.Configuration<br...
Hi Satya, I will do these tests, for the time being, do u have any idea, how to overcome this situation, like i kill the running processes as it goes...
Actually we are handling database connections from one centralized place, so i double check it, but could find bug. if u run the following script:...
Hi, We have application ruuning on two web servers built on ASP.NET technology. These two web servers using SQL Server 2000 Enterprise Edition...
Separate names with a comma.
