Clearing Disconnected Users

Here it is. Create a SQL Job that executes this to clear users that have logged off.

USE ExactMAX

DELETE FROM ERMUD where MachineName not in (select distinct(hostname)

from master.dbo.sysprocesses where program_name=’Exact MAX’) AND

MachineName not like ‘%##Terminal##%’ and CompanyName not like ‘%-##-%’

Leave a Reply

Your email address will not be published. Required fields are marked *