instead of deleting rows, you can truncate them (which delete ALL rows and reset identity columns).
truncate table YourTableName
>Hi,
>
>We will soon be ready to move a VB-SQL 2000 app from testing to production. We will be deleting records from most of the tables (excluding some settings tables) accumulated during testing. Creating a SQL script to do this is simple enough.
>
>My question is this: I would like to reset the identity seed for these tables after deleting the records. How should I do this? Can it be done as part of my script?
>
>Thanks in advance.
>
>Al
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com