Error in deleting

When I am trying to delete the record from flat table it gave me following
error and that record doesn't have a constraints / triggers so why it's
giving me this error.
SQL Server Enterprise Manager
Key column information is insufficient or incorrect. Too many rows were
affected by update.
OK Help
Thanks in advance.
you don't have a unique identifier/key
http://sqlservercode.blogspot.com/
"Rogers" wrote:

> When I am trying to delete the record from flat table it gave me following
> error and that record doesn't have a constraints / triggers so why it's
> giving me this error.
> --
> SQL Server Enterprise Manager
> --
> Key column information is insufficient or incorrect. Too many rows were
> affected by update.
> --
> OK Help
> --
> Thanks in advance.
>
>
|||You need to have a primary key.
"Rogers" wrote:

> When I am trying to delete the record from flat table it gave me following
> error and that record doesn't have a constraints / triggers so why it's
> giving me this error.
> --
> SQL Server Enterprise Manager
> --
> Key column information is insufficient or incorrect. Too many rows were
> affected by update.
> --
> OK Help
> --
> Thanks in advance.
>
>
|||you need to have a primary key on that table .
"Rogers" wrote:

> When I am trying to delete the record from flat table it gave me following
> error and that record doesn't have a constraints / triggers so why it's
> giving me this error.
> --
> SQL Server Enterprise Manager
> --
> Key column information is insufficient or incorrect. Too many rows were
> affected by update.
> --
> OK Help
> --
> Thanks in advance.
>
>