>it is possible to reset a autoinc in a table of sql server
>
>
>
>now it 89000
>
>
>and i have delete all the table can i put it back to 1 ????
>
>thanks
If the table has no records, just TRUNCATE TABLE MyTable, but if it has, you could use SET IDENTITY_INSERT MyTable ON (I hope this is the right statement, I can't check it right now) and then insert into idenetity field the value you want.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.