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...