Vlad Drumea is not a fan of sequences:
This is a script that I wrote to help me next time I might need to bulk reseed out-of-sync SQL Server sequences tied to default constraints.
Click through for a demo of the problem, as well as Vlad’s script to fix it.