Clear GP Users

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)

About Vincent Stefanetti

Vincent Stefanetti Senior Consultant MAX Manufacturing Software Working with MAX and Related Technologies Since 1987 MAX ERP System Implementations and Projects MAX, Dynamics GP, Synergy, Event Manager, Crystal Reports, SQL Reporting Services, Database and System Migrations and Updates, MAX Training Classes - All Levels, Custom Reporting.
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply