• Please show the code for the sproc. Does the sproc reference any UDFs by any chance?

    Also, what tool/mechanism did you use to determine that this sproc was doing the blocking and what the actual locked pages/objects were?

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