Re: Cannot Add Subaccounts!

Mike Davis ( (no email) )
Tue, 23 Jun 1998 13:26:21 -0400

dbtransfer??

-----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