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

I know its frustating on such client! You could run server side tracing in this case that will minimize impact that might get due in running PROFILER. http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm http://www.mssqltips.com/tip.asp?tip=1035 http://sqlblog.com/blogs/linchi_shea/archive...