Orders are not in numerical order

Problem

You see that order number are not sequencial for example after 1892 you get 2412, it skipps like a couple of hundred orders.

Solution

There is no solution. This behaviour comes from SQL server. We do not know if it is bound to a specific version.

It was noticed on SQL Server 2012.

Related articles

http://stackoverflow.com/questions/17587094/identity-column-value-suddenly-jumps-to-1001-in-sql-server

Troubleshooting guidelines