Found this on the support.microsoft site.
If this error is encountered, the parameter for the locks can be increased
using sp_configure. Each lock requires 32 bytes of memory, which is
allocated statically when SQL Server is started. Therefore, the value for
LOCKS should be set high enough to avoid running out of locks. Note however
that the memory allocated to LOCKS reduces the amount of memory available
for the SQL Server cache.
With SQL Server version 4.2, the locks may be set to a maximum of 500,000.
At 04:16 PM 5/17/2001 -0400, you wrote:
>what buttons do i press in mssql7 server to get rid of this?
>
>ODBC Error Code = S1000 (General error)
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]SQL Server has run out of
>LOCKS. Rerun your statement when there are fewer active users, or ask the
>system administrator to reconfigure SQL
> Server with more LOCKS.
>
>thnx,
>
>Alexander Sicular
>Chief Technology Architect
>The Neurological Institute of New York
>Columbia University
>212.305.1318
>as867 {at} columbia [dot] edu
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
