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