Delete Locks in SQL Server

Problem

Can't edit data in INPUT and Project database in DATA DESIGN. 

Solution

Multiple times on production environments I have found the table [dbo].[WH_Lock] had a record for a user that was no longer using the database. Probably this was caused by gINT not closing gracefully. This stopped users editing data in INPUT and stopped me editing the database in DATA DESIGN. 

The solution is to delete the record(s).  Open the database in SSMS, right click on the table, select Script Table As > Delete To, then edit the query to remove the Where line, and execute it.