• 1) sp_whoisactive can help you see locking waits in real time (along with a TON of other useful features - and it is FREE)

    2) the most common cause of lock waits is suboptimal indexing

    3) others provided you with links to help you figure out what is being blocked by what

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service