I have an identity column in my table and after deleting all the rows of a table (say 10 rows, where last identity value is 10. ) if I start inserting rows the identity value is coming 11, which is not required.
I want to restart my Identity columnvalues from 1…..I tried from Enterprise Manager by deleting Identity column and again creating it, but it didn’t work.
Please give me the solution.
