Posted by David Portas on 07/08/06 10:20

dinu wrote:
> Dear Friends,
> I have table contain 2000 out of those some are
> duplicate when i select duplicate records by using Enterprise Manager
> and make modification to one of those duplicate records the following
> message flashes/display.
>
> key columen information is insufficient or incorrect.Too many rows were
> affected by update
>
> pls suggest what is this and how to solve this problem
>
> Thanks in advance
>
> Dinesh Patwal

Before you can edit the data in Enterprise Manager you need to add a
unique constraint or unique index. To facilitate that it may help to
use SELECT DISTINCT to eliminate duplicates and copy the data to a new
table. It rather depends on just how you want to eliminate the
duplicate data. You can Google for lots of previous posts on this topic
in this group and in the microsoft.public.sqlserver groups.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

[Back to original message]