You cannot prevent deadlocks completely.
to find the objects thats causing the deadlock,
issue
exec splock

you will get the objectid s and the type of locks issuesd and resource on
which the lock issued



Roji. P. Thomas
SQL Server Programmer ;)
________________________
----- Original Message -----
From: <K.[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Friday, November 28, 2003 4:07 PM
Subject: Deadlock


> Hi all
>
> How to prevent Deadlock situations. How to find tables or transactions on
> which Deadlock occurred. ?
>
> Pls help me
> Manoj kumar
>
>
>
> *********************************************
> This communication which may be confidential and privileged and the
> views expressed herein may be personal and are not necessarily the
> views of Coats Ltd. It is for the exclusive use of the intended
> recipients(s). If you are not the intended recipient(s), please note that
> any distribution, copying or use of this communication or the information
> in it is strictly prohibited. If you have received this communication in
> error, please notify us by email (Apps.[Email Address Removed] or telephone
> our technical support helpdesk at Coats Ltd. +44 (0)20 8210 5100
> (UK 0830h - 1800h, Mon-Fri, GMT) and then delete the e-mail and
> any copies of it.
> **********************************************
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Get today's cartoon: http://www.LazyDBA.com
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page