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:
Open the SQL Enterprise Manager in the Microsoft SQL Manager program group.
From the Server menu, select SQL Server, then Configure. The Server Configuration/Options dialog opens.
In the Server Configuration/Options dialog, select the Configuration page.
Find locks in the list.
Increase the number of locks.
Exit the SQL Enterprise Manager.
Result: The change takes place the next time the SQL Server is restarted.
Database management for SQL Server.