>I have tbale which has a Primary Key.
>I now want to set it to autoincrement.
>I ritht cick on the column, but the iDENTITY field is disabled.
>
>Is there a way to change a PK to be Autoincrementing.
>Regards,
>Gerard
Are you trying to do this from VS (through the server explorer) or using SQL Server Management Studio?
Is the PK an (exact) numeric field?
I do not have any problems changing the Identity Specification in the column properties to Yes and then changing the identity increment property.
Semper ubi sub ubi.