Troubleshooting problems with locking in SQL Server 2012 If you have problems with SQL Server 2012 locking, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because many SQL Server 2012 locking bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time...