
Last month I have upgraded my sqlserver from 2008 to 2012. and restart SQL Server 2012.
I have reviewed my table records are inserting in proper manner (auto increment) but suddenly it jumps to 11498 and onward . All the table in the database containing identity column.

This may be helpful for you.
http://www.codeproject.com/Tips/668042/SQL-Server-2012-Auto-Identity-Column-Value-Jump-Is
Thanks

Mahesh ChandPosted Nov 9, 2013, 8:03 AM
Puru, so where is the solution? You should post the solution, not the link to Codeproject :). People expect the solution to be in your blog.