SQL Developing Locks

• abhi_develops

  Say Hey Kid

  Points: 676

  More actions

  April 9, 2003 at 3:16 am

  #106216

  Hi Folks,

  I keep on getting this error everytime I run a stored procedure. I am using ISOLATION LEVEL SERIALIZABLE and basically inserting roughly 200,000 records into a table.

  Server: Msg 1204, Level 19, State 1, Procedure chkBulkInserts, Line 9

  The SQL Server cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users or ask the system administrator to check the SQL Server lock and memory configuration.

  What should I try to do?

  Cheers!

  Abhijit

• Jeremy Kemp

  SSCertifiable

  Points: 6754

  More actions

  April 9, 2003 at 3:50 am

  #453538

  I had this problem when I was loading rows in bulk. I used use:

  sp_tableoption '<table_name>', 'table lock on bulk load, 'true'

  This locks the whole table whilst you load the records and it solved the problem.

  Jeremy