--Script to view all current processes / sessions on the server:

select * from master.dbo.sysprocesses