Hi all. I am a new SQL Profiler user trying to baseline our eCommerce site. I am receiving EventClass 80, Missing Join Predicate (hereinafter MJP), often enough to be concerned about what may happen during very high traffic. I have isolated the query, included at the bottom of this post (cleaned up)...

We are using SQL Server 2000. In production we are facing deadlock problems. If we try to run a trace then users starts complaining that there are not able to get into the application. What do you think are the options that we have to trace down deadlock issues? We have hundreds of stored procedures...