We have a program that runs on multiple computers same time. That program runs other programs and when job is over it updates a table with a new record.These jobs are running 24/7 and only once in a while I am getting the following error:
"Cannot update cursor 'cursorname' because it's read-only".
Is it because of a simultaneous access to that table?
I am thinking to use TRY...CATCH...FINALLY to catch that error and retry.

Any ideas?