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 —————————————-
http://spaces.msn.com/members/dineshasanka

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://www.sql-server-performance.com/at_sql_locking.asp
http://www.sql-server-performance.com/reducing_locks.asp
http://msdn.microsoft.com/archive/en-us/dnarsqlsg/html/sqlperftune.asp Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>