Posted by Roy Harvey on 06/20/07 17:02

What it seems to be saying is that there is already a row in the table
with the value N'DEV2\sam', and the index UserInfo_Login has a unique
constraint that does not permit duplicates. However it is possible
the index has multiple columns. To know exactly you would need to
know the details of the definition of the index UserInfo_Login on the
table UserInfo. You could find that out by running:

EXEC sp_helpindex Deve2_SITE..UserInfo

Roy Harvey
Beacon Falls, CT

On Wed, 20 Jun 2007 09:51:15 -0700, SJ <sjourdan@gmail.com> wrote:

>Hi!
>
>I am trying to do a simple udpate on a table and I am getting the
>error:
>
> "Cannot insert duplicate key row in object 'UserInfo' with unique
>index 'UserInfo_Login'.The statement has been terminated."
>
>Here is the command I am trying to run
>---
>USE Deve2_SITE
>
>update UserInfo set tp_Login=N'DEV2\sam', tp_Email=N'test@test.com',
>tp_Title=N'Samson, Sammy'
>WHERE (tp_Login=N'DEV\sam')

[Back to original message]