Press "Enter" to skip to content

Resetting Sequences on Tables with Default Constraints

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.