>I'd like to thank all of you who replied to my question.
Peter,
I think this may also indicate a problem with your database or ap somewhere. If you can't do a select cause some transaction has locked the records needed, perhaps you should look at your transactions.
Are you beginning a transaction and not closing it as quickly as possible?
Are any or your trasactions started and then in a wait state for the user to do something before it is closed?
Also, what is your default transaction isolation setting? Maybe it is set to strict for you application. See the SET TRANSACTION ISOLATION LEVEL topic in SQL books on line.
BOb
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