>>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
>
>It's protecting you from using IDENTITY as PK from the start < g >
>Cetin

Now Cetin, there's nothing wrong with using an identity column as your PK. Just don't use the identity column as your clustered index < bg >
- Keith