>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.

see http://msdn.microsoft.com/en-us/library/ms188059.aspx

identity_insert

Don't use it unless you are copying in related records and the identity column has to remain the same.