Every so often, our SQL 7.0 server starts spitting back errors complaining that it is out of locks. I let SQL Server dynamically allocate as much memory as it needs to service lock requests, so Im at a loss what else I can do. I am profiling various queries and gradually decreasing lock requirements where possible, but with close to 600000 lines of code, its going to be a long time before I get it optimal. Is there anything I can do in the meantime to increase the lock limit ? Thankyou.