472,328 Members | 1,374 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,328 software developers and data experts.

ASP.Net 2 And MS SQL 2005 SP1 Transactions?

Hi,
I have an issue where transaction deadlocks are created from time to time.
But unless my understanding of deadlocks is fundamentally floored then these deadlocks should not occur.

The code in one web site creates a transaction and starts performing several database statements.

The code in another web site is creates and database connection and a command object then runs a complex select statement (normally takes around 20 seconds).

How can a deadlock occurs when one of the 1 of the 2 conflicting statements contains no transaction and is only a select statement?

I could understand a normal lock, as the select statement may need to wait for the transaction in the other site to end but not a deadlock.
Mar 1 '07 #1
0 800

Sign in to post your reply or Sign up for a free account.

Similar topics

7
by: Richard Maher | last post by:
Hi, I am seeking the help of volunteers to test some software that I've developed which facilitates distributed two-phase commit transactions,...
11
by: Mike P | last post by:
I've been using C# transactions for a while and had no problems with them. Using try catch blocks I can trap basically all possible errors and...
1
by: SQLJunkie | last post by:
Hi, I have installed SQL 2005 RTM on a new server and I keep getting this error (described below) quite frequently. Was wondering if anyone has a...
4
by: ~john | last post by:
I'm trying to get a transaction to work with PHP 5.1.4 and SQL Server 2005... The first SQL statement deletes several rows in the database. The...
1
by: Nacho | last post by:
Hello, I'm trying to follow some sql sentences that my system send to SQL 2005 express and I don't have a deep knowlegde of databases. I know...
12
by: Rami | last post by:
I have some requirement for an automated payment system. The system has four machines setup as follows: 1- Two machines have a clustered database....
3
by: Lee T. Hawkins | last post by:
I am having a number of problems over the last two full days trying to get an ASP.NET 2.0 application to connect to a SQL Server 2005 database... ...
1
by: BobRoyAce | last post by:
I have a situation where I have one procedure that executes a bunch of database code in a transaction. In this procedure, in the middle of the...
2
by: Tony K | last post by:
I have a form that involves a datagrid view to be filled after a start and end date are selected from 2 DateTimePicker fields using the Short...
3
by: xscorpion | last post by:
Hi, Someone can help, I develop a windows aplication that uses oracle conections, when I load the data in page load to fill a dropdow of users...
0
by: tammygombez | last post by:
Hey fellow JavaFX developers, I'm currently working on a project that involves using a ComboBox in JavaFX, and I've run into a bit of an issue....
0
by: tammygombez | last post by:
Hey everyone! I've been researching gaming laptops lately, and I must say, they can get pretty expensive. However, I've come across some great...
0
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
0
better678
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
0
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
0
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.