>>Hello, All
>>
>>In development mode, using a MSDE database, I've done tests, including inserting the records in tables with @@identity field.
>>
>>Now it's time to send the database to the customer. How can I reset those fields back to 0? At this moment, I don't have any records in my tables, but if I insert a new record, the @@identity field will have the value starting from my tests.
>>
>>Thank you.
>
>Remove all of the test rows with TRUNCATE TABLE mytablename and the identity fields should start with the default seed value again. HTH

Thansk you very much. This is exactly what I need. Three stars :)