Forum Discussion
With some more investigation, I've found that the tables we have been updating up till now are not declared as IDENTITY in SQL, but rather the third party that created the system have them working functionally as IDENTITY fields, but rather than let SQL maintain this, they do it in the backend of there system
The new system I am currently trying to integrate too uses IDENTITY declarations, which implies that the way we have been updating has been wrong
Any assistance with what the correct way is, would be appreciated.