Posted by Alex Kuznetsov on 06/20/07 18:42

On Jun 20, 11:51 am, SJ <sjour...@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't...@test.com',
> tp_Title=N'Samson, Sammy'
> WHERE (tp_Login=N'DEV\sam')
> --
>
> Any ideas?

In addition to Roy's advice, do you have triggers on your table?

http://sqlserver-tips.blogspot.com/

[Back to original message]