Information générale
Titre:
SQLServer Blocks Simultaneous Updating
Versions des environnements
Network:
Windows 2000 Server
Hi all,
We encountered the below scenario.
User A access record 1 in screen. After saving the record, User B tried to access the same record but the screen freezed. From the SQLServer Enterprise Manager, we observerd the below under Management/Locks/Process ID:
Object Lock Type Mode Status Owner Index Resource
--------------------------------------------------------------------------
mydata.dbo.A KEY S WAIT Xact Demas (800091e63fc0)
If User B access different record, there is no issue. Please advise. Thanks in advance.
PS: We are using remote view auto transaction; Shared Connection.
Regards,
Farouk Yew Abdullah
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