Re: [Emerald] HELP! SQL Server Error: 8646

Josh Hillman ( (no email) )
Tue, 24 Oct 2000 10:44:58 -0400

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.


----- Original Message -----
From: "Ronnie Franklin" <>
To: <>
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
> I get to where it completes... I usually move the date by 1/2 of what I
> 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

For more information about this list (including removal) go to: