Monday, June 18, 2012

Identity property remains gaps

Let say you have a table and use identity property. It is ok, but I really hope that you are aware of the bug that remains gaps in identity if you restart MS SQL Server service. Please vote http://connect.microsoft.com/SQLServer/feedback/details/739013/alwayson-fail
over-results-in-reseed-of-identity
Thanks