|
|
Problem in creating primary key in SQL Server
Tue, 12/29/2009 - 12:55
I was tring to set one column as primary key for my table h_emp_m which already have records but while creating it i encountered the following error.I think it is because of duplicate values for that column.If it is because of duplicate values then how can i remove duplicate values from my table.
- Unable to create index 'PK_H_EMP_M'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 1. Most significant primary key is '001221'.
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not create constraint. See previous errors.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
Similar entries
- No process is on the otherend of the pipe Microsoft SQL Server Error: 233
- Too many backup devices specified for backup or restore; Only 64 are allowed SQL server 2000 error
- IIS problem:The Web server reported the following error
- 500 - Internal server error generic error message in ASP pages
- Data Source Name(DSN) Connection to database in ASP using DSN
- SQL Server does not allow remote connections Error 26
- MMC cannot open the file SQL Server Enterprise Manager.MSC
- Script action to job in Server Management Studio Express
- connection with the server could not be established asp.net web application
- The dependency service or group failed to start SQL server Start problem