What version of SQL are you running?

What is the purpose of the task at hand, do you just want to boot people out or are you setting the DB into single user mode?

sysprocesses and sysdatabases are also depreciated