Just run following query:
DBCC CHECKIDENT('YourTableName', RESEED, 0)
This one is often used after truncating table - under usual curcumstances without this command, next record you add will have primary key one higher than the latest added record (even you just truncated table).
Loading ...