Hi,
it runs fine for me but the SQLStatement associated with the blocking session is NULL. The SQLStatement text for the session being blocked is ok.
When i run DBCC inputbuffer(spid) against either session i get text returned.
am i missing something here ?
Any help welcome:)
Eamon