Clear Locked users GP 2010

psolutions
psolutions used Ask the Experts™
on
I have this script that cleans out locked users in GP 10.

SELECT * FROM DYNAMICS..ACTIVITY
SELECT * FROM DYNAMICS..SY00800
SELECT * FROM DYNAMICS..SY00801
SELECT * FROM TEMPDB..DEX_LOCK
SELECT * FROM TEMPDB..DEX_SESSION

It works great, only problem is it doesn't do the job in GP 2010.  Does anyone know what table(s) i am missing here, sa is locked and needs to be manually cleared out? Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Victoria YudinOwner / Dynamics GP Consultant

Commented:
The script you posted is only selecting data, not actually deleting it. So this is not going to clear anything out.  However, unless you are 100% sure that no one is in GP, you do not want to run the delete equivalents of this, as that will 'force quit' everyone out of GP and if users are in the middle of entering or posting transactions you could cause some damage to those transactions.

So let's go back a step...clearing out users is a solution, what exactly is the issue you are experiencing?  
Found it, anyone else that has this issue check these tables for locked users.
Dynamics database.. JCACTVTY...TTACTVTY..UPR10300
Company Database ..SY02800...AF40202..GL50400

I found mine in JCACTVTY, Thanks

Author

Commented:
fixed my issue

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial