Clearing locks in a database through ScfUtils (Model Explorer)
You can clear locks in a database through ScfUtils.
If you have installed Modeler to the default locations, ScfUtils resides in:
<<INSTALLDIR>>\Modeler\Exe\SCFUtils.exe
For information about clearing locks in a database through Model Explorer, see Clearing locks on a database.
To clear all locks in a database:
 |
You must be a Database Administrator to clear all locks in a database.
|
ScfUtils -clearalllocks Enterprise "<database-ref>"
Where:
• <database-ref> specifies the reference to the database in which to clear all locks.
Enter the database reference in the following format: \\SQL\<server-name>@<instance-name>\<database>
Example:
ScfUtils -clearalllocks Enterprise "\\SQL\MyServer@MODELER\MyDatabase"
To clear locks for a specific user:
|
|
You must be a Database Administrator to clear locks for other users.
|
ScfUtils -clearuserlocks Enterprise "<database-ref>" "<user>"
Where:
• <database-ref> specifies the reference to a database in which to clear locks for a specific user.
Enter the database reference in the following format: \\SQL\<server-name>@<instance-name>\<database>
<user> specifies a user to clear locks.
Example:
ScfUtils -clearuserlocks Enterprise "\\SQL\MyServer@MODELER\MyDatabase" "domain\user"