Issue: Occasionally, after installing a new server, you will want to change the BI numbers of future Batch Instances so that there’s no duplication in BI numbers.


Solution: You can change a setting in the Database to whatever number you want moving forward.

The following query needs to be executed on batch_instance table. You will need to figure out the Hex – Decimal conversion (The 1001 in my example will start from BI3E9).




ALTER TABLE batch_instance AUTO_INCREMENT=1001;




DBCC CHECKIDENT (batch_instance, RESEED, 1001);