SQL Active Users, List and Delete

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]

PlusPoint Bullet