Let’s say you want to kill all running process by a particular user or account. The following query will help you to find all related SPID for all processes initiated by a particular user or account.
You may need to replace “
USER_ACCOUNT” in the query with your target account name.
SELECT spid from master..sysprocesses WHERE loginame = N'USER_ACCOUNT'
After you obtain the list of SPID, it’s time for you to reload your weapon, you can simply execute KILL command against those processes.