Re: Cannot Add Subaccounts!

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

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. <>
To: <>
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. (
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today |