/
How to Clear SQL Locks

How to Clear SQL Locks



Description of Issue

A table in SQL is locked by a user that is no longer in the system and it needs to be cleared out.  



Context
  • Munis

  • SQL

  • SSMS

  • System Administration



Cause

Munis was improperly closed or crashed leaving the connection to a table still open.



Resolution

Contact Tyler System Management Support or log a case via the Online Support Client Portal. Support will typically need SQL server access to resolve this issue. 



Additional Information












Related content

View Database Locks
View Database Locks
More like this
Munis SQL Locks
Munis SQL Locks
More like this
Unable to delete PO lock in Open Purchase Order Locks program
Unable to delete PO lock in Open Purchase Order Locks program
More like this
Release failed error in General Journal Entry
Release failed error in General Journal Entry
More like this
Unable to Lock Vendor Summary Table
Unable to Lock Vendor Summary Table
More like this
Record locked by another user message in Account Master - another user has account master in Update mode for same account
Record locked by another user message in Account Master - another user has account master in Update mode for same account
More like this