Clearing locks on a database (Model Explorer)

Model, Component, and Package Management > Model management > Model Explorer > Working with databases > Clearing locks on a database (Model Explorer)

Databases are locked while you are working on them so that other users cannot modify them at the same time. Databases can also become locked if Modeler crashes while you are working.

Use one of the following programs to clear locks on a database:

• Model Explorer

• Integrity Modeler

• SQL Server Administrator or the Model Management API

• ScfUtils

Clear All Locks on a database:

Before clearing database locks, ensure that no one else is using the database.

You must be a Database Administrator to clear all locks on a database.

To clear all locks on a database, right-click on the database, and then select Clear Locks > Clear All Locks. All locks on the database are cleared.

Clear Principal Locks on a database:

Administrators can clear database locks for specific users.

You must be a Database Administrator to clear principal locks on a database.

1. Right-click on the database, and then select Clear Locks > Clear Principal Locks....

2. In the user selection dialog, enter a user name, then click OK.

3. The locks are cleared.