Re: [Emerald] Please help, Questions on Emerald & SQL....

Dale E. Reed Jr. ( (no email) )
Sun, 25 Jul 1999 16:09:09 -0700

Eric wrote:
>
> Dale,
> Thanks! I will give this a go and let you know if I have any problems.
> I don't know if you caught my earlier post "[Emerald] SQL Transfer
> question...", When we transfer the Emerald DB to a new one, the data used
> is significantly lower on the new DB than the old. Any ideas on this?

Its probably just because the stats of the DB are off. My answer to
#4 below applies here as well:

> > > 4) After running a few scripts to change the dates for "PaidThru",
> > > "maExpiredDate", and "OverDue", the logs are getting full, and truncating
> > > the transaction log doesn't seem to clear it out. What is the SQL script to
> > > clear out the logs, and are there any dangers in doing this once in a
> > while?
> >
> >You probably need to run a CheckDB and then re-calc the size of
> >the DB.

-- 

Dale E. Reed Jr.      Emerald and RadiusNT__________________________________________IEA Software, Inc.    www.iea-software.com

For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart