Corrupted table problem

[Dave Navarro]

I have a table that is corrupted (it has a number of duplicate records
in it).

When I attempt to delete the duplicate records from the Enterprise
manager I get an error.

So I need to programatically remove them using ASP code.

I have no idea how to do that. Can anyone point me to some sample code
or a description on how to attack this.

--Dave

[Bob Barrows]

Dave Navarro wrote:

> I have a table that is corrupted (it has a number of duplicate records
> in it).
>
> When I attempt to delete the duplicate records from the Enterprise
> manager I get an error.
>
> So I need to programatically remove them using ASP code.
>
> I have no idea how to do that. Can anyone point me to some sample
> code or a description on how to attack this.
>
> --Dave

If your table is so "corrupted" that you cannot remove rcords using EM, why
do you think you will be able to remove via asp" They both use similar
methods to modify the data in your database.

Why don't you tell us what error message you received so we can have some
clue as to what is going on.

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"