|
Posted by SJ on 06/20/07 16:51
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')
--
Any ideas?
Navigation:
[Reply to this message]
|