--XAI04440.906153301/mail.barak.net.il
**********************************************
** THIS IS A WARNING MESSAGE ONLY **
** YOU DO NOT NEED TO RESEND YOUR MESSAGE **
**********************************************
The original message was received at Fri, 18 Sep 1998 18:52:28 +0200 (IST)
from walnut.iea-software.com [207.53.165.8]
----- The following addresses had transient non-fatal errors -----
<Emerald-list@mail.extent.com>
----- Transcript of session follows -----
<Emerald-list@mail.extent.com>... Deferred: Connection refused by main.nmt.co.il.
Warning: message still undelivered after 4 hours
Will keep trying until message is 3 weeks old
--XAI04440.906153301/mail.barak.net.il
Content-Type: message/delivery-status
Reporting-MTA: dns; mail.barak.net.il
Arrival-Date: Fri, 18 Sep 1998 18:52:28 +0200 (IST)
Final-Recipient: RFC822; Emerald-list@mail.extent.com
Action: delayed
Status: 4.4.1
Remote-MTA: DNS; main.nmt.co.il
Last-Attempt-Date: Fri, 18 Sep 1998 23:15:01 +0200 (IST)
Will-Retry-Until: Fri, 9 Oct 1998 18:52:28 +0200 (IST)
--XAI04440.906153301/mail.barak.net.il
Content-Type: message/rfc822
Return-Path: <emerald-return@iea-software.com>
Received: from walnut.iea-software.com (walnut.iea-software.com [207.53.165.8])
by mail.barak.net.il (8.9.1/8.9.1) with ESMTP id SAA20958
for <Emerald-list@mail.extent.com> Fri, 18 Sep 1998 18:52:28 +0200 (IST)
Received: from walnut.iea-software.com (walnut.iea-software.com [207.53.165.8]) by walnut.iea-software.com (NTMail 4.00.0020/NT6651.00.c89adb95) with ESMTP id za000909 for <emerald@iea-software.com> Fri, 18 Sep 1998 09:22:37 +0100
Received: from [207.53.173.26] by walnut.iea-software.com (NTMail 4.00.0020/NT6651.00.c89adb95) with ESMTP id zxiaaaaa for <emerald@iea-software.com> Fri, 18 Sep 1998 09:22:37 +0100
Message-ID: <36028A19.D622BD5C@iea-software.com>
Date: Fri, 18 Sep 1998 09:28:09 -0700
From: "Dale E. Reed Jr." <daler@iea-software.com>
Organization: IEA Software, Inc.
X-Mailer: Mozilla 4.06 [en] (WinNT; I)
MIME-Version: 1.0
To: Michael Whisenant <mwhisen@airnet.net>
CC: Emerald Lista <emerald@iea-software.com>
Subject: Re: CallDetails
References: <000101bde056$8fa97a60$620c20c8@KEVIN> <4.0.2.19980916130847.0095b4c0@mail.airnet.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-ListMember: Emerald-list@mail.extent.com [emerald@iea-software.com]
Michael Whisenant wrote:
>
> Dale,
>
> This is a posting that you made and I have a few questions regarding the
> CallDetails that may clear up some points. From the first portion it
> creates the table inside Emerald and
> populates the fields. Since this is a portion of the information contained
> in calls the database size should not grow extremely large. However, if
> you wanted to place this into another database what would the process be,
> and/or advantages of doing so?
We've actually done some custom installations for larger customers to
put
the calls table into its own database, to prevent it from causing
problems
with the Emerald database. There isn't any reason why you couldn't do
that
with the calldetails as well. Just create the new database, and fully
qualify the objects. For Example, if you create a new DB called
Emerald2,
and created the CallDetails table in there, you would need to modify the
trigger to insert into Emerald2..CallDetails rather than just
CallDetails.
> I have a question on the trigger and exactly when it is used. Are the
> records inserted each time the calls arrive? Or could this be scheduled to
> run as a scheduled task nightly?
The trigger is ran at the exact moment the record is inserted (and one
for
each record inserted). It can be scheduled, but its not an exact art
and
requires additional modifications beyond just running a couple of
commands.
> Select @ast=i.AcctStatusType From inserted i IF @ast = 2 BEGIN Insert INTO
> CallDetails Select DateAdd(Second, 0-i.AcctDelayTime, i.CallDate),
Just fully qualify CallDetails here with the name format of:
Database..Table
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com--XAI04440.906153301/mail.barak.net.il--