InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 01:58:00 GMT20http://www.sqlservercentral.com/Forums/Topic511316-92-1.aspxDropped all the Foreign Keys that were associated with the Person primary key.Dropped the Unique Clustered Index over Person.Created the Primary Key as Clustered over Person_IDAdded the Foreign key constraints back.Just wanted you to know.Thanks,LarryWed, 04 Jun 2008 08:34:11 GMTLawrence M. Meklemburghttp://www.sqlservercentral.com/Forums/Topic511316-92-1.aspxI have 7 tables all associated with what a Primary Key on a table called Person. The column for the Primary Key is called Person_ID.The problem is when I restored the database from a SQL 2000 backup to SQL 2005 Enterprise Edition DBCC CheckDB reported errors in the database associated the Person table. I noticed that in error someone had made the Person_ID a non-clustered index (PK_PersonID), so I scripted a query to drop the index and create a new unique, clustered index over Person_ID. That fixed my DBCC CHECKDB error, but left me without a Primary Key on the Person table. How do I create the primary key on Person_ID for the Person table?Thanks,LarryWed, 04 Jun 2008 06:51:09 GMTLawrence M. Meklemburg