Hi Gail (I hope you see this)

I have databases using SQL 2005, 2008 and 2008 R2.

I want to drop a non clustered primary key and immediately add a clustered version of the same index.

Will SQL Server still “protect me” in this circumstance if this is done while the database is in use? I won't get dupes or anything in the PK column?

Script would be something like this:

ALTER TAble Table1

drop PK_Table1

ALTER TABLE Table1

ADD CONSTRAINT [PK_Table1]

PRIMARY KEY CLUSTERED

(

[ID] ASC

)