Not able to set is Identity key as Yes in SQL Server

Question

I just not created a new database with 2 tables in it. In a table, I have set a column as a primary key and trying to change its properties i.e. setting is Identity to YES, but am not able to do so.

Any ideas/suggestions?

Answer 1

Make sure the datatype is int and not something else.

You can't have an identity on a different type.

Answer 2

Do you have data in the table? You can't make an IDENTITY column if you do.