SQL Server Performance Forum – Threads Archive
Duplicate server process Id in Sql Server
Using Enterprise Manager – Current Activity recive the message Error 1505: create unique index terminates because a duplicate key was found most significant primary key is 63. The Table sysprocess how me only one spid 63. The Artisan tool show me 2 processes 63. How delete this process 63. The alternative was stop the Sql Server, but the second day appear the problem. Thanks in advance. Heraclio Cejas C.This error occurs when you attempt to create a unique index and more than one row contains the duplicate value. You must review your index objective. If your index does not need to be unique, remove the UNIQUE keyword and reissue the CREATE INDEX statement. However, if you still want to create a unique index, you must query the table in question and remove the rows in error. For more information about the CREATE INDEX statement in books online. To find the duplicate rows, issue a GROUP BY statement:
Eg:
SELECT * FROM tblTest
GROUP BY strLastName, strFirstName (In future kindly post the threads in relevant forums.) Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Pardon: Sql Server generate duplicate key, always the spid 63. The version Sql Server is 7.00.961 and Windows is 4.0 (1381). Thanks.
quote:Originally posted by satya
This error occurs when you attempt to create a unique index and more than one row contains the duplicate value.
You must review your index objective. If your index does not need to be unique, remove the UNIQUE keyword and reissue the CREATE INDEX statement. However, if you still want to create a unique index, you must query the table in question and remove the rows in error. For more information about the CREATE INDEX statement in books online.
To find the duplicate rows, issue a GROUP BY statement:
Eg:
SELECT * FROM tblTest
GROUP BY strLastName, strFirstName (In future kindly post the threads in relevant forums.) Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Eg:
SELECT * FROM tblTest
GROUP BY strLastName, strFirstName (In future kindly post the threads in relevant forums.) Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
As suggested try to find the duplicate rows and delete them or remove UNIQUE keyword while creating the index. Also try to re-apply SP4. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>