Ever wonder how to get a list of active users in a MAX or Synergy database?
In SQL Management Studio, enter:
SELECT DB_NAME(dbid) as “Database”, loginame as LoginName, spid
FROM sys.sysprocesses
WHERE dbid > 0
AND DB_NAME(dbid) = ‘ExactMAXxxx’
This presents a list of user ID numbers, then you can delete a user with the following:
KILL [id number]