Annoying Identity Column Big Jump Solution In SQL Server 2014

Share on your favorite platform

Many developers reporting that there is a bug in SQL server 2014 in which the id columns with auto increment feature having a big jump every time the server is restarted. Microsoft says that this is a feature rather than a bug. Some developers could live with it, but many others find it very frustrating especially when that column is to be showing in the client application, for instance if this number is used to provide a sequential invoice number. As a developer, you will get a endless stream of support calls about these unexpected jumps.

from stackexchange user complain

Solution and workaround

To solve this problem once and for all, open programs, and under “Microsoft SQL server 2014” , and then under “configuration tools” folder open SQL server configuration manager. You need, of course, to open it as an administrator.

Now, right click the SQL server and go to “properties”, and in “startup parameters” add the following parameter : -T272 . click apply and restart the SQL service and now your all set and the identity column is consistent again.


Share on your favorite platform

Leave a Reply

Your email address will not be published. Required fields are marked *