Re: HELP!! SQL Failure

Dale E. Reed Jr. ( (no email) )
Sun, 07 Dec 1997 14:26:25 -0800

Ronnie D. Franklin wrote:
>
> This appears to be the only corrections/errors:
>
> Checking Emerald
> Checking 8
> The total number of data pages in this table is 2.
> The number of data pages in Sysindexes for this table was 19161. It has been corrected to 2.
> The number of rows in Sysindexes for this table was 637063. It has been corrected to 50.

This affects the displayed size. It was probably displaying much larger than it
actually was (most likely the calls table).

> Msg 7997, Level 16, State 1
> 'OperatorAccess' does not contain an identity column.
>
> Msg 7997, Level 16, State 1
> 'RadValues' does not contain an identity column.

These two are fine. If you are still getting the error, try creating another
database and using SQL Transfer and test the new one.

> Ronnie
>
> On Sunday, December 07, 1997 2:39 PM, Dale E. Reed Jr. [SMTP:daler@iea.com] wrote:
> > On Sun, 7 Dec 1997 ronnie@itexas.net (Ronnie D. Franklin) wrote:
> >
> > > Thanks Dale,
> > >
> > > I ran the Checkdb.sql and got a ton of "results".. I see several places
> > > that it corrected items.. anything specfic that I should be looking for???
> >
> > Probably page allocation corrections or something similar to a page
> > correction.
> >
> >
> > Dale E. Reed Jr. (daler@iea.com)
> > _________________________________________________________________
> > IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> > Internet Solutions for Today | http://www.iea-software.com
> >
> >
> > ----------------------------------------------------------
> > Emerald Mailing List listserver@emerald.iea.com
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com

-- Dale E. Reed Jr.  (daler@iea.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com