Click here to Skip to main content

Go to Technical Blog

Failover or Restart Results in Reseed of Identity – FIX

Gordon Beeming

Rate me:

0.00/5 (No votes)

14 May 2013CPOL

6.7K

2

Simply run the script and then every time SQL is restarted, all your Identity columns will be reset to the latest available seed.

Views

Daily Counts

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Gordon Beeming

Architect SSW

South Africa

Father | Husband | SSW Solution Architect | Microsoft MVP (GitHub & Azure DevOps) | Dev⭐Ops

Comments and Discussions

Go to top