Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2008 Server
>If you are getting into the code where the table is opened exclusively you already have an exclusive lock it can't be a sharing problem.
>
>So that rules out issues related to locking/contention.
>
>If this is intermittent then this is some sort of OS file system or permissions issue.
>
>I would suspect Anti-Virus as others have. This is the most common problem for intermittent file operation failures on writes especially.
>
>Another thing to think about: Where do the files live? Are they in AppData or a User folder? If not and Windows UAC is on Windows will move those file under you to a private user store. So if the files live in the programs folder and permissions have not been set explicitly for that user the files are virtualized and can be moved under you - possible that only manifests intermittently as a file is moved while writing to it. Easiest way to check for this is to run the app as Run As Administrator or explicitly give full permissions to the user running the app...
>
>+++ Rick ---
Thanks, Rick. Some good ideas there.
Tamar
Précédent
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