I recently migrate a DataBase from Microsoft Access in a replication scenario with those evil replication autonumbers to SQL Server 2008 R2
The PK of all tables where the replication autonumbers in access.
I want to keep the same PK with there values but I would like to know if it's possible to make the auto-number restart at beginning to fill empty "range". At the moment, it increment starting at the highest value. So if I have those PK (1, 2222,
3333, 5555) I would like that the next value is gonna be 2 instead of 5556
Do I also have to execute a script (if it's possible) against every table of the database ?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.