I've a table tEmployee which has column EmpID. EmpID is a Identity column seed as 1 and increment as 1. Now already records are present in the table.
I would like to modify the seed value as 10000000 and increment value as 1. But existing records should not get affected. How to achieve this?
Please do assist