Just to make sure about this before you do it. The clustered index will be an integer and always sequential? Say for some reason ID 302 gets skipped, Will a new 302 ever get inserted?
>I am really a dunce when it comes to understanding how SQL Server works. But the PK is integer and from what you are saying 'no downsides'. Now I will be connecting to all my customers and one-by-one changing this PK constraint to clustered.
>Thank you.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer