• Hi,

    Check sp_whoisactive procedure after running the above statements. It will tell you which session id is blocing the table.

    OR

    U can check the information sys.dm_tran_locks to see if there are any shared and exclusive locks on it.

    For more information goto

    Adam machanic blog.

    http://sqlblog.com/blogs/adam_machanic/archive/tags/sp_5F00_whoisactive/default.aspx