>>>Hi,
>>>
>>>I know I have done this type of change before (on some other customers' server) but this time I am hitting a wall. I need to set a column of a table to be Identity (that table is empty).
>>>
>>>But when I connect to the customer SQL Server, go to SSMS - connect using SQL server authentication. My SQL Server password has the following roles set in the database:
>>>db_datareader, db_datawriter, db_owner.
>>>Yes, when I try to set the PK column of a couple of table to Identity I am denied.
>>>
>>>What am I missing? TIA.
>>
>>Reading your question again..
>>
>>Odd. Is the column already set as a primary key? If so, remove the key and then set as identity, and then set as primary key.
>>
>>The column must be int or double by the way.
>
>I found the solution. In the Options I have the "Prevent saving change that require table re-create" checked. Once I unchecked the box I can make the change to Identity.
>
>Thank you.
Yes, this is exactly what I suspected was happening here, that's why I wanted to see the exact error.
If it's not broken, fix it until it is.
My Blog