How to Clear Disconnected Users from Dynamics GP

 

delete from DYNAMICS..ACTIVITY

    where USERID not in

        (select loginame from master..sysprocesses) 

delete from tempdb..DEX_SESSION 

    where session_id not in 

        (select SQLSESID from DYNAMICS..ACTIVITY) 

delete from tempdb..DEX_LOCK 

    where session_id not in 

        (select SQLSESID from DYNAMICS..ACTIVITY) 

delete from DYNAMICS..SY00800 

    where USERID not in 

        (select USERID from DYNAMICS..ACTIVITY) 

delete from DYNAMICS..SY00801 

    where USERID not in 

        (select USERID from DYNAMICS..ACTIVITY)