2005

regards
Gerard


>What type of sqlserver are you using? 2005? Compact Edition?
>
>>Hi Einar.
>>I'm using Management studio. Yje PK is an INT field.
>>
>>Regards,
>>Gerard
>>
>>>>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.