--reset identity values to 0 if you have deleted a large number of rows and want to reset.  Run again to update to current number of rows

use [DB_NAME};
exec sp_MSforeachtable @command1 = 'PRINT ''?''; DBCC CHECKIDENT(''?'', RESEED)'
go