Tag Archives: MS SQL 2012

Failover or Restart Results in Reseed of Identity – FIX

Simple run the script and then every time SQL is restarted all your Identity columns will be reset to the latest available seed. This script is a fix for the issue logged here. Hope it helps others like it’s helping me.   USE master; GO CREATE PROCEDURE sp_FixSeeds2012 AS BEGIN –foreach database DECLARE @DatabaseName varchar(255) DECLARE DatabasesCursor CURSOR READ_ONLY FOR […]