On Tuesday, June 23, 1998 12:36 PM, Mike Davis wrote:
> checkident fixed. I'm still running sql 6.0 (not by choice). Is the
> "dbtransfer" you mentioned not an option with 6.0 or is it just a script??
>
>
> -----Original Message-----
> From: Dale E. Reed Jr. <daler@iea-software.com>
> To: emerald@iea-software.com <emerald@iea-software.com>
> Date: Tuesday, June 23, 1998 1:27 PM
> Subject: Re: Cannot Add Subaccounts!
>
>
> >Mike Davis wrote:
> >>
> >> database went into recover after a reboot, turned flag off per microsoft,
> >> database came back. All other functions work fine exept we cannot add
> >> subaccounts. Get "Sql Command Failed". Any ideas on what's going on????
> >> Kinda hard to sign up new folks like this.
> >
> >In the event of bad crashes like this, I would recommend creating a
> >fresh database and using the DB transfer to copy the data into a known
> >clean database. This may be an identity problem, though. Try
> >running the DBCC CheckIdent(SubAccounts) and see if it corrects
> >the problem (its one of the lines in the checkdb.sql file).
> >
> >--
> >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