You can define a sequence to start at any number you like: (If the column already has a default value, you need to remove that first - in a separate statement.) A sequence works a lot like an identity, but you don't have to disrupt existing values or the column definition per se.
The only trick is to remember to not specify the value for Tracking Number, and let the DB do its thing.
When Subscriber inserts are replicated back to the Publisher, identity columns must be managed to avoid assignment of the same identity value at both the Subscriber and Publisher.
Is the new value to use as the current value of the identity column.
WITH NO_INFOMSGS Suppresses all informational messages. The specific corrections made to the current identity value depend on the parameter specifications. DBCC CHECKIDENT returns the current identity value and the current maximum value of the identity column.
Make sure you turn it back off when you complete the update.
:) https://msdn.microsoft.com/en-us/library/ms188059you need to use an identity column? For example, since SQL Server 2012 (and azure, too), there are these things called sequences.