OFFLINE TO ONLINE SWITCH

Normally when you switch from offline to online, order submission fails sometimes.

This is because the primary key duplication error, db doesnt recognise the primary key as the incremented number and we might have to reseed it.

Apply the below script:

DBCC checkident ('[dbo].[Order]')

DBCC checkident ('[dbo].[Order]', reseed)

DBCC checkident ('[dbo].[Order]', reseed, {number}) 

DBCC checkident ('[dbo].[OrderItem]')

DBCC checkident ('[dbo].[OrderItem]', reseed)

DBCC checkident ('[dbo].[OrderItem]', reseed, {number}))

DBCC checkident ('[dbo].[OrderItemIngredient]')

DBCC checkident ('[dbo].[OrderItemIngredient]', reseed)

DBCC checkident ('[dbo].[OrderItemIngredient]', reseed, {number}))