RE: [Emerald] I CAN NOT BILL

Ken Sorenson ( (no email) )
Tue, 15 Feb 2000 15:27:49 -0600

This is a multi-part message in MIME format.

------=_NextPart_000_0028_01BF77C9.37C76710
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

I have seen the same locks issue, but it happened when I updated calls, via
database admin maintenance.
-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com]On Behalf Of Kenneth Gustav
Eitenmiller Jr
Sent: Tuesday, February 15, 2000 1:59 PM
To: Emerald Mailing List
Subject: [Emerald] I CAN NOT BILL
Importance: High

This is in response to the fact that I CAN NOT BILL my customers.
I have NOT BEEN ABLE TO BILL since 02.09.2000 when I wrote my first
message.
I CAN NOT BILL.

I got the following message while trying to run updatecall.sql from Query
since it just locks up under emerald admin.

What does this mean and how do I fix it?

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.

I REALLY NEED TO BE ABLE TO BILL...
There are no users connected to the SQL Server except the desktop of the
server itself, I am running the query from there.

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_0028_01BF77C9.37C76710
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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

I have=20seen the same locks issue, but it happened when I updated calls, via =database=20admin maintenance.
-----Original Message-----
From:=20 emerald-request@iea-software.com=20 [mailto:emerald-request@iea-software.com]On Behalf Of Kenneth =Gustav=20 Eitenmiller Jr
Sent: Tuesday, February 15, 2000 1:59=20 PM
To: Emerald Mailing List
Subject: [Emerald] I =CAN NOT=20 BILL
Importance: High

This is in response to the fact that =I CAN NOT=20 BILL my customers.
I have NOT BEEN ABLE TO BILL since =02.09.2000=20 when I wrote my first message.
I CAN NOT BILL.
 
I got the following message while =trying to run=20 updatecall.sql from Query since it just locks up under emerald=20 admin.
 
What does this mean and how do I fix=20 it?
 
Msg 1204, Level 19, State 3
SQL =Server has run=20 out of LOCKS.  Re-run your command when there are fewer active =users, or=20 ask your System Administrator to reconfigure SQL Server with more=20 LOCKS.
Msg 3701, Level 11, State 1
Cannot drop the table=20 '#temp_accountlist', because it doesn't exist in the system =catalogs.
Msg=20 3701, Level 11, State 1
Cannot drop the table '#temp_serverlist', =because=20 it doesn't exist in the system catalogs.
 
I REALLY NEED TO BE ABLE TO =BILL...
There are no users connected to the SQL Server except the desktop =of the=20 server itself, I am running the query from there.
 
Thanks,
Ken
 
Kenneth Gustav Eitenmiller =Jr
Network Support=20 Specialist
keitenmiller@hughestech.net
----------------------------------------------
www.hughestech.net
Hughes =Business=20 Technologies
7825 Forest Hills Road
Rockford, Illinois=20 61111
815-282-5151
815-282-5529=20FAX
------=_NextPart_000_0028_01BF77C9.37C76710--