Blocking Process - Blank

[meninblack]

We have an issue where one process will be blocking, causing other processes to be blocked until this has been released.

When you look into the process/query of the process that is blocking, it is empty!

Any idea's how we can found what the process is actually doing or has been doing?

We are running SQL 2000 at the moment.

Thanks in advance.
Kris

 

[Crowley16]

use sys.sysprocesses, there's a sql_handle column in there which can be fed to sys.dm_exec_sql_text to get the full sql being run.

Note, the stmt_start and end columns will define the actual section of the sql that's being run, you need to divide these numbers by 2 though...

--------------------
Procrastinate Now!