mikeob

 Profile Answers by mikeob 

• Jun 17th, 2009

 

One can look at master.sysprocesses blocked column to look at what is blocking what.

deepaish

 Profile Answers by deepaish 

• Aug 16th, 2009

 

You can execute the stored procedure sp_who , this will give you process id which is blocking what. This is more usefull since sometimes user doesn't have restricted permission for master database.