7.0 has a "repair database" function that when ran at it's most agressive
will just delete the records.. and that is what I need to do, just have not
taken the time to do it.. I know where the 2 records are and I just avoid
deleting them.
> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of Josh Hillman
> Sent: Tuesday, October 24, 2000 9:45 AM
> To: emerald@iea-software.com
> Subject: Re: [Emerald] HELP! SQL Server Error: 8646
>
>
>
> Have you tried running the checkdb.sql script from Query Analyzer
> (SQL 7) or
> ISQL/w (SQL 6.5) on the Emerald database? Maybe that'll take care of the
> problem. Be sure to be logged in as "sa" when doing it.
>
> Josh
>
> ----- Original Message -----
> From: "Ronnie Franklin" <ronnie@itexas.net>
> To: <emerald@iea-software.com>
> Sent: Monday, October 23, 2000 11:34 PM
> Subject: RE: [Emerald] HELP! SQL Server Error: 8646
>
>
> > I got an answer from one of the techs yesterday.. so yes they still
> > monitor.. but probably not this late!
> >
> > I have had the same problem with a couple of corrupted
> records.. asked and
> > never got a real fix.. so here is my work around.
> >
> > I start by doing a
> >
> > Delete from Calls
> > where (calldate > yy/yy/yy 00:00:01 AM) and
> > where (calldate < xx/xx/xx 12:59:59 pm)
> >
> > Then when it bombs out, I just keep moving the xx/xx/xx date backwards
> until
> > I get to where it completes... I usually move the date by 1/2 of what I
> am
> > trying to delete so I can narrow down faster..
> >
> > Once you have found the time frame of the 1 or 2 records that
> are causing
> > the problem then just adjust the date and time to avoid those records.
> >
> > Probably not the best way, but it does work!!
> >
> > Ronnie
>
>
> ------------
>
> This is a user supported list. If you require assistance from IEA
> Software's
> Support Engineers, please check out our Support resources at
> http://www.iea-software.com/support.
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
------------
This is a user supported list. If you require assistance from IEA Software's
Support Engineers, please check out our Support resources at
http://www.iea-software.com/support.
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart