>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.
What is the exact error message you're getting?
If it's not broken, fix it until it is.
My Blog