<div>
The script you posted is only selecting data, not actually deleting it. So this is not going to clear anything out. &nbsp;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.<br />
<br />
So let's go back a step...clearing out users is a solution, what exactly is the issue you are experiencing? &nbsp;
</div>


<div>
<div class="content wysiwyg-content">
I have this script that cleans out locked users in GP 10. <br />
<br />
SELECT * FROM DYNAMICS..ACTIVITY<br />
SELECT * FROM DYNAMICS..SY00800 <br />
SELECT * FROM DYNAMICS..SY00801 <br />
SELECT * FROM TEMPDB..DEX_LOCK <br />
SELECT * FROM TEMPDB..DEX_SESSION<br />
<br />
It works great, only problem is it doesn't do the job in GP 2010. &nbsp;Does anyone know what table(s) i am missing here, sa is locked and needs to be manually cleared out? Thanks<br />

</div>
</div>


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


Clear Locked users GP 2010

Microsoft Dynamics is a line of enterprise resource planning (ERP) and customer relationship management (CRM) software applications. Dynamics can be used with other Microsoft solutions, such as SharePoint, Yammer, Office 365, Azure and Outlook. Dynamics ERP comprises a group of enterprise-resource-planning products includes Dynamics AX (formerly Axapta), a multi-language, multi-currency enterprise software with business management features for financial, human resources, and operations management; Dynamics GP (formerly Great Plains Software); Dynamics NAV (formerly Navision) for financials, supply chain, and people; Dynamics SL (formerly Solomon IV)for project-driven organizations; Dynamics C5 (formerly Concorde C5) for manufacturing, supply chains, analytics and electronic commerce; and Dynamics CRM.