2 processes are intertwined with each other - each of them is waiting for the other to finish before proceeding.
One way to help prevent deadlocking is by making sure that your indexing strategy is as efficient as it can be (e.g. making sure that a particular query is using an appropriate index as opposed to doing a table scan <which can lock the entire table> when executing. Mike Mike Flanigan UPSHOT Marketing Director of E-Solutions Office 804.422.9673 Cell 804.357.1259 http://www.upshot.net/ -----Original Message----- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 1:33 PM To: CF-Community Subject: OT: MS SQL Server What is happening when cold fusion or asp is returning a "SQL Dead lock" -Shawn Regan ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
