• DBA

    identity jumping from default to bigger large number

    Overview of the issue: It is small web based productions application and hosted in SQL express 2012 for the license costing. Issue is whenever SQL restarted for whatever reason identity numbers are changed very bigger and identity jumping from one to other digits. To fix this in our case we cannot do this at database level or table schema script level to NOCACHE or disable the IDENTITY CACHE, since it is been enabled many databases and application code changes are not advised. Resolution: Enable trace flag T272 at instance level in the start up parameters.