Just load checkdb.sql into isql_w and execute it against your Emerald
database. The checkdb.sql that comes with Emerald will work fine for
you. I did put the newest one in /emerald/updates a few minutes
ago. The only difference is that it includes a section at the
bottom to update all of your indexes as well.
> If this script temporarily puts the database out of service,
> should I set RadiusNT to authenticate via a text file during
> the process?
As it checkes each table, it will lock it. However, for most tables
(except maybe the calls table) it should only be a couple of
> To "recalculate the size of the DB" I assume I would just open
> the Emerald databse in the SQL Enterprise Manager and click the
> "Recalculate" button.
> I would do this AFTER running the checkdb.sql script. Does that all sound okay?
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list, including removal,please see http://www.iea-software.com/maillist.html