sql server 6.5 'error running out of locks' | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

sql server 6.5 ‘error running out of locks’

I am using sqlserver 6.5
I am trying to insert records from a query to another table.
I am getting the error ‘sql server running out of locks.pls contact system administrator’ Why this is coming? How to avoid it? Thanks for any help.

Will this help
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_10184880.html —————————————-

IN SQL 6.5 you have to configure the locks and restart the SQL services to take on the new settings. Tips to reduce locking:
http://msdn.microsoft.com/archive/en-us/dnarsqlsg/html/sqlperftune.asp Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.