Skip Navigation
What are table locks?
Answer ID 9836   |   Last Review Date 03/11/2019

What is a table lock?


All Sites, All versions.


Locked database tables, often seen via "Locked" error or warning messages.


A table, or portion of a table, that is inaccessible for a period of time is a normal part of the use & operation of a database. When the database is using a portion of a table, that portion id first locked, ensuring that another process cannot attempt to make changes to it at the same time.  Some examples of things that can cause table locks:

  • Backups being performed.
  • Multiple reports running on the replication server.
  • Poorly formed database queries being run against the replication server.