We recently had a customer inquire about how they could determine which user was currently locking their bank reconciliation window. After taking a step back and contemplating our approach, we realized that the lock record is found within the tempdb database.
A simple query would be needed to get this information:
SELECT A.USERID, L.* FROM tempdb.dbo.DEX_LOCK L, DYNAMICS.dbo.ACTIVITY A
WHERE L.session_id = A.SQLSESID
AND table_path_name like ‘%CM20500’
And knowing which tables are affected helps expedite the search.
In theory, this same query (referencing a different table) can be used when you encounter similar situations in Microsoft Dynamics GP.
Visit us at www.BondConsultingServices.com or just pick up the phone and call 562.988.3451. For any other Microsoft Dynamics 365 inquires – support@BondConsultingServices.com
