Tech Off Post

Single Post Permalink

View Thread: SQL Transaction Blocking On Foreign Key
  • User profile image
    MetaGunny

    Also, I know for a fact it's blocking on the Customers table and the resource type is a KEY.

    I ran one of those sql locking stored procedures.  It shows a WAIT on the customers table, the key resource type.