Categories
Dynamics NAV Microsoft SQL Server

There are some objects locked in the database. You must unlock these objects before upgrading the database

—————————
Microsoft Dynamics NAV Development Environment
—————————
There are some objects locked in the database. You must unlock these objects before upgrading the database.
—————————
OK
—————————

Solution:
Execute the following SQL Query, remind to USE your database name (replace NAVDatabase)

USE [NAVDatabase]

UPDATE [Object] SET [Locked] = 0, [Locked By] = '' WHERE [Locked] = 1

then close the query window (otherwise the connection will still remain active).

Did my solution solve your problem? Leave a reply.

3 replies on “There are some objects locked in the database. You must unlock these objects before upgrading the database”

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.