>>>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.
>
>My the way my Primary Identity column is numeric(6,0) and it works.
I guess having 0 decimals is OK. News to me. I've always used int (or double if int wasn't big enough).
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________