Hi Bob.
>VALIDATE DATABASE will run whether it's open SHARED or EXCLUSIVE, it just won't do the rapair if its not exclusive.
I wouldn't use VALIDATE DATABASE inside an application. It doesn't really do any repair (or at least not much). It's definition of "repair" for most types of damage is to ask the user if they want to remove the offending item from the database. First, that's not a dialog I want my users to see. Second, while removing a table from the database may make the DBC valid, it sure can hose the table and parts of your application that expect to use the table.
VALIDATE DATABASE is really something you should use when you get errors indicating that something is wrong with the DBC and you are prepared to spend some time cleaning up *after* VALIDATE DATABASE has completed.
Doug
Précédent
Suivant
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