troubleshooting Question

Clear Locked users GP 2010

Avatar of psolutions
psolutions asked on
Microsoft Dynamics
3 Comments1 Solution1986 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
psolutions

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros