Reseed all Autonumber fields in all tables with the following query:
EXEC sp_MSForEachTable ' IF OBJECTPROPERTY(object_id(''?''), ''TableHasIdentity'') = 1 DBCC CHECKIDENT (''?'', RESEED, 0)
Visit the DevX Tip Bank