Hi, I need help regarding the identity column. I have a column whose Identity seed was 1 when the column was initially created. Now I have to change the seed to -2,147,483,648 I am having a plan; I am creating a temporary table with two columns both of them INT without any IDENTITY property specified. I am inserting the Identity column values from the table in question into this table; the other column being null next I will update the column2 of that table by simply adding -2,147,483,648 to the column1 of that row this will give me the expected IDENTITY value if I would have set the SEED to -2,147,483,648. Now finally to change the seed in the original table I will create a new column and add all values in that column and then make it to IDENTITY In short how do You make a column IDENTITY through ALTER Column statement and that the column is already having values in it? Any help shall be appreciated!