>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.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________