[Emerald Digest]

emerald-digest-request@iea-software.com
Mon, 15 Jun 1998 00:00:00 -0700

Message 1: NTMail -Emerald
from "Waldemar Born" <WallyB@LIP.net>

Message 2: Trim Call records
from "Kelly Wright" <kelly@buz.net>

Message 3: Re: Trim Call records
from Robert Boyle <robert@garden.net>

Message 4: 5:Invalid procedure call
from "Jorge Pocaterra" <junior@enlared.net>

Message 5: Re: Database Size.
from Robert Boyle <robert@garden.net>

Message 6: Re: Database Size.
from "Scott Burch" <sburch@bmni.com>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: NTMail -Emerald
From: "Waldemar Born" <WallyB@LIP.net>
Date: Sun, 14 Jun 1998 12:28:56 +0200

Hi there,

I'm thinking of working with the NTMail-dll.
My questions to all who have this situation (NTMail + Emerald):

How safe is this?
Does ist make life easier? ;)
Will there be any problems with my current installation? (several domains
configured)

I'm currently not sure, how this dll works... Do I need to create the users
in NTMail or Emerald?

Waldemar Born
WallyB@LIP.net

Magenta Computer AG
Germany

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Trim Call records
From: "Kelly Wright" <kelly@buz.net>
Date: Sun, 14 Jun 1998 07:05:46 -0400

This is a multi-part message in MIME format.

------=_NextPart_000_0135_01BD9762.DAB005C0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

How do you trim the call records in emerald. I have tried the script =
and still have 400k lines that is taking up 115Meg of space. =20

Is there some command that will dump all the records? I need to recover =
some space.

Kelly Wright (kelly@buz.net)
BuzNet Communications
http://www.buz.net
972-644-0440

------=_NextPart_000_0135_01BD9762.DAB005C0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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

How do you trim the call records in emerald.  I =have=20tried the script and still have 400k lines that is taking up 115Meg of=20space. 
 
Is there some command that will dump all the =records?  I=20need to recover some space.

Kelly Wright (kelly@buz.net)
BuzNet =Communications
http://www.buz.net
972-644-0440=
------=_NextPart_000_0135_01BD9762.DAB005C0--..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 3 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Trim Call recordsFrom: Robert Boyle Date: Sun, 14 Jun 1998 13:41:01 -0400At 07:05 AM 6/14/98 -0400, you wrote: >> How do you trim the call records in emerald. I have tried the script and> still have 400k lines that is taking up 115Meg of space. > > Is there some command that will dump all the records? I need to recoversome> space.To delete selectively,DELETE FROM Calls WHERE CallDate < 'June 1 1998'To delete EVERYTHINGTRUNCATE TABLE Calls-RobertRobert Boyle Server Co-location,Garden Networks Internet Access,50 Diller Ave Development & ConsultingNewton, NJ 07860 (973)300-9211 Ext.1038AM-8PM Mon-Fri EST http://www.garden.netLucent RABU & Software.Com Post.Office VAR..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 4 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: 5:Invalid procedure callFrom: "Jorge Pocaterra" Date: Sun, 14 Jun 1998 13:59:46 -0400Hi DaleWhen i try to e-mail invoice it gives me an error5:Invalid procedure callWhat's wrong???ThanksJorge Pocaterra T.Junior@enlared.net..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Database Size.From: Robert Boyle Date: Sun, 14 Jun 1998 14:20:25 -0400At 08:13 AM 6/13/98 -0400, you wrote: >> We have about 350 MBRs and appoaching 200Meg in size. I have run the SQL> scripts to delete the call records with little effect. I know there is> something else that needs to be done but don't know. I figure the dbshould> be about 60-70 Meg in size. Those are your calls. We have about 1450 MBRs and one month of calls and ourdatabase is only 29MB. Is your log file on the same device? If so, think aboutmoving it to its own device.>> > Is there any other maintenance that needs to be done. I have seperated the> logs for the emerald db so I know it is not the logs.Also try a:DBCC CHECKDB(Emerald)See what errors it lists.-Robert..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Database Size.From: "Scott Burch" Date: Sun, 14 Jun 1998 19:45:56 -0700We have the same problem..A HUGE DB. What command can we use to delete thecall information?-----Original Message-----From: Robert Boyle To: emerald@iea-software.com Date: Sunday, June 14, 1998 11:22 AMSubject: Re: Database Size.>At 08:13 AM 6/13/98 -0400, you wrote:>>>> We have about 350 MBRs and appoaching 200Meg in size. I have run the SQL>> scripts to delete the call records with little effect. I know there is>> something else that needs to be done but don't know. I figure the db>should>> be about 60-70 Meg in size.>>>>Those are your calls. We have about 1450 MBRs and one month of calls andour>database is only 29MB. Is your log file on the same device? If so, thinkabout>moving it to its own device.>>>>>>>> Is there any other maintenance that needs to be done. I have seperatedthe>> logs for the emerald db so I know it is not the logs.>>>>Also try a:>>DBCC CHECKDB(Emerald)>>See what errors it lists.>>-Robert>>>>>