Hi.
i have created a Table in Sqlserver 2008r2 as below:
Table=Country(CountryId (Int,not null,Unique Index) ,CountryName (NvarChar))
I had inserted data into this table , but i decided to delete them , now when i want to reinsert data into the table , it has memorized it's previous Indexes and
CountryId starts from (for example 14), while i want to start it from number 1.
what shall i do?