Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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?
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement