John Baird
Coatesville, Pennsylvania, United States
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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only