Here are described most common causes of deadlocking and how to avoid them:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8
_con_7a_8i93.asp

Best Regards,

Mihail Todorov
System Analyst
ICT Department
Kamenitza AD
+359 (898) 774 284
+359 (32) 626 892



-----Original Message-----
From: SACHIN AGARWAL /SOFT/INFOTECH/BKC
[mailto:mssqldba-ezmlmshield-x34711202.[Email address protected]
Sent: Wednesday, March 30, 2005 1:41 PM
To: LazyDBA Discussion
Subject: java.sql.SQLException


Dear friends,

i wanna to know cause of following exception. i am getting
it from SQL Server 2000
java.sql.SQLException: Transaction (Process ID 102) was deadlocked on
lock resources with another process and has been chosen as
the deadlock victim. Rerun the transac
tion.


Thanks & Regards
Sachin Agarwal


--


"This e-mail message may contain confidential, proprietary or legally
privileged information. It
should not be used by anyone who is not the original intended recipient. If
you have erroneously
received this message, please delete it immediately and notify the sender.
The recipient
acknowledges that ICICI Bank or its subsidiaries and associated companies,
(collectively "ICICI
Group"), are unable to exercise control or ensure or guarantee the integrity
of/over the contents of the information contained in e-mail transmissions
and further acknowledges that any views
expressed in this message are those of the individual sender and no binding
nature of the message shall be implied or assumed unless the sender does so
expressly with due authority of ICICI Group.Before opening any attachments
please check them for viruses and defects."




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]

MS Sql Server LazyDBA home page