Additional Locks Configuration

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:

  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.

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

More information


Database management for SQL Server.