TheSQLGuru (3/31/2014)
If you shut down SQL Server there is a known bug that advances the identity values. I don't know if there is a fix for that or not.
according to MS it's not a bug, it's by design.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉