>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