Can you supply a sample of the trace? You may have some DTS jobs running.
Just speculating until I see a trace output.

You could also try running Profiler to get the text of the query as well as
the login name and workstation.


----- Original Message -----
From: "Subhash Chandra "
<mssqldba-ezmlmshield-x25525151.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Saturday, May 26, 2007 2:32 AM
Subject: Deadlock Detection


> Hi All,
>
> Using trace 1204, 1305 I found details of many deadlocks in errorlog. But
> in
> some deadlock table that is locked is nowhere used by stored procedure
> executed by participating SPIDs.
> If there is no operation on a table by specified stored proceudre then how
> this table is causing deadlock.
>
> Thanks & Regards,
> Subhash
>


MS Sql Server LazyDBA home page