Additional Locks Configuration

About this task

If the SQL Server generates an error that looks like this on rollover:

Error #S1000 SQLSERVER has run out of locks. Re-run your command when …

You can do the following to increase the number of locks:

Procedure

  1. Open the SQL Enterprise Manager in the Microsoft SQL Manager program group.
  2. From the Server menu, select SQL Server, then Configure. The Server Configuration/Options dialog opens.
  3. In the Server Configuration/Options dialog, select the Configuration page.
  4. Find locks in the list.
  5. Increase the number of locks.
  6. Select OK.
  7. Exit the SQL Enterprise Manager.

Results

The change takes place the next time the SQL Server is restarted.