SQL 2005 Primary Key Error
Posted on 2007-10-09
I have a table, t_Month, that I needed to refresh with data from our development box. The primary key on this table is Month_ID so I removed the key, re-imported the data, and then tried to add the key back on. When I try to save the table I get the following error:
- Unable to create index 'PK_t_Month'.
CREATE UNIQUE INDEX terminated because a duplicate key was found for object name 'dbo.t_Month' and index name 'PK_t_Month'. The duplicate key value is (1).
Could not create constraint. See previous errors.
The statement has been terminated.
I can't find another index called PK_t_Month anywhere. Not really sure what to do here, even went so far as to bounce the server on the chance that the key was stuck in memory somewhere.
Thanks in advance,