Re: [Emerald] Pre-Invoice

Ed Miller ( (no email) )
Wed, 23 Jun 1999 13:10:46 -0400

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Gustavo Russo: "RE: [Emerald] Type mismatch problem in workstation under SQL 7.0"
Next message: Dale E. Reed Jr.: "Re: [Emerald] Problem on displaying logged in users. (fwd)"
Maybe in reply to: Ed Miller: "[Emerald] Pre-Invoice"
Next in thread: Dale E. Reed Jr.: "Re: [Emerald] Pre-Invoice"

> Ed Miller wrote:
> >
> > We are still having poblems with Pre-Invoice.
> >
> > We finalley got it to run a week or 2 ago without errors.
> >
> > Now when run it (2.5.285) we get 'SQL Error Adding Callhistory Item'
> >
> > What gives? If I hit enter it keeps going.
>
> Go into Enterprise Manager and drill down to your CallHistory
> table. Double click it and then select the advanced options.
> On the primary key tab, remove the primary key and click save.
>
> > How offen should we run it?
>
> Before you do an invoice run.
>
> > Why does it take SOOOO LOOOONG?
>
> Its designed to not be demanding on the system. There are some things
> you can look at to speed it up, but mostly is giving your SQL Server
> more RAM (and configuring SQL Server to use it).

In configuration I have the tempdb ram set at 96MB on a 128 MB system
What else should I look at?

Previous message: Gustavo Russo: "RE: [Emerald] Type mismatch problem in workstation under SQL 7.0"
Next message: Dale E. Reed Jr.: "Re: [Emerald] Problem on displaying logged in users. (fwd)"
Maybe in reply to: Ed Miller: "[Emerald] Pre-Invoice"
Next in thread: Dale E. Reed Jr.: "Re: [Emerald] Pre-Invoice"