[Emerald] SQL - locks

Kenneth Gustav Eitenmiller Jr ( keitenmiller@hughestech.net )
Wed, 9 Feb 2000 13:55:03 -0600

This is a multi-part message in MIME format.

------=_NextPart_000_0A6E_01BF7305.436338B0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

What does this mean and how do I fix it? Occured while running =
updatecalls.sql or whatever its labeled...

Msg 1204, Level 19, State 3
SQL Server has run out of LOCKS. Re-run your command when there are =
fewer active users, or ask your System Administrator to reconfigure SQL =
Server with more LOCKS.
Msg 3701, Level 11, State 1
Cannot drop the table '#temp_accountlist', because it doesn't exist in =
the system catalogs.
Msg 3701, Level 11, State 1
Cannot drop the table '#temp_serverlist', because it doesn't exist in =
the system catalogs.

Thanks,
Ken

Kenneth Gustav Eitenmiller Jr
Network Support Specialist
keitenmiller@hughestech.net
----------------------------------------------
www.hughestech.net
Hughes Business Technologies
7825 Forest Hills Road
Rockford, Illinois 61111
815-282-5151
815-282-5529 FAX

------=_NextPart_000_0A6E_01BF7305.436338B0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

What does this mean and how do I fix =it? Occured=20while running updatecalls.sql or whatever its labeled...
 
Msg 1204, Level 19, State 3
SQL =Server has run=20out of LOCKS.  Re-run your command when there are fewer active =users, or=20ask your System Administrator to reconfigure SQL Server with more =LOCKS.
Msg=203701, Level 11, State 1
Cannot drop the table '#temp_accountlist', =because it=20doesn't exist in the system catalogs.
Msg 3701, Level 11, State =1
Cannot=20drop the table '#temp_serverlist', because it doesn't exist in the =system=20catalogs.
 
Thanks,
Ken
 
Kenneth Gustav Eitenmiller =Jr
Network Support=20Specialist
keitenmiller@hughestech.net
----------------------------------------------
www.hughestech.net
Hughes =Business=20Technologies
7825 Forest Hills Road
Rockford, Illinois=2061111
815-282-5151
815-282-5529 FAX
------=_NextPart_000_0A6E_01BF7305.436338B0--