Hi!

Just generate SQl Script for all your tables, delete them all, then re-create them again. Re-creating table from zero will reset the current identity value. If you have no daat in table, it is safe and easy (just right click on the table in Enterprise Manager and find the Generate SQL Script... or something like that).

HTH.

PS: is not it the question for SQl Server forum???

>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.