about identity column

Aug 28 2013 5:48 AM

i set id as identity(1,1) column,i entered about 10 columns,i deleted the data.
after if we are entering data id starts at 11.but i need to start from 1.
can anyone says this............
plz urgent?

Answers (3)

rollback of last updated queries in sql server

i need for this