Shafat - I no not want to change the field used as the primary key at all. In fact, I will create a new non-clustered index for that field. I just want to change the clustered index key since that value is copied to all of the other non-clustered indexes and I want the clustered index to be smaller in size, sequential and always increasing in value to ensure any inserts are appended to the end of the clustered index.

Thanks,

Dave