Why did my client ID jump by 1000?

This only occurs in Microsoft SQL 2012. It makes the ID numbers look funny on Customerid, Submid, Subtypeid, Jobs, PrintJobs etc. because after the restart it jumps the number by 1000.

The below link talks about either setting up a Sequence for the ID number or using a Startup parameter.
The startup parameter affects all databases on the SQL server.

 

http://www.codeproject.com/Tips/668042/SQL-Server-Auto-Identity-Column-Value-Jump-Is

0 Comments

Article is closed for comments.
Powered by Zendesk