Re: Cannot Add Subaccounts!

Dale E. Reed Jr. ( (no email) )
Tue, 23 Jun 1998 10:21:14 -0700

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  |