I had the same issue when updating to an Oracle linked server: "ROW-00014: Cannot update row as the data in the database has changed". If you do an update on...

Good question. The old version returned data straight away

I am running SQLServer 2005, that explains why it didn't work

Thanks for the sp_addmessages idea. I recently discovered I could use the Transfer Error Messages task in SSIS (as a...

I did run the sp_configures as you specified. I still got the same error:

"Ad hoc updates to system catalogs are not allowed"

Why does the insert SQL need to be in...

What form does this DTS take to copy sysmessages? I'm running the below code and getting the error "Ad hoc updates to system catalogs are not allowed"

--Copy custom messages from...