I have had to move everything over to a brand new server from my old server.
Did an IMPORT of the database(s) to new server.All tables imported perfectly and no lost data. Permissions have been properly assigned.
I had to redo all PK assignments in all the tables as that did not seem to carry over with the import.
PROBLEM: After a record loads and a data update has been entered I am now receiving the error: 'Cannot update identity column 'ID'
Column ID is the PK and is set to increment +1 on the creation of a new record.
- I can read in existing records fine.
- I am able to create a new record fine.
- I cannot edit or update any existing record at all.
- All XSD files have been updated and reloaded.
- All connection strings have been changed and all appear to be working fine.
This all worked fine on my old server (running Server 2008 - SQL Server 2016) and still works today as I just tried it. I can create a new record and then do edits with no errors on the old server. Something is overlooked evidently on the new server (running Server 2016 - SQL Server 2016) that allows edits of current records. I have compared the old DB to the new and all settings "appear" to be set the same.
I am obviously overlooking something. Can anyone make a suggestion as to where to look or what to check please?