• How can we help you with so little information? No code for the stored procedure, no code actually doing the blocking, object that is blocked, other code requesting the lock it can't get, no table definitions, execution plans, etc., etc.

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