Monthly Archives: October 2015

Review SQL Server Instance Configuration

SELECT  *FROM    sys.configurationsORDER BY name ;GO

Posted in Uncategorized | Leave a comment

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 … Continue reading

Posted in Uncategorized | Leave a comment