EXEC SP_WHO    'KISADMIN'

Select * From sysprocesses

Select * From SYSDATABASES

Select sysprocesses.login_time as 连接开始时间, sysprocesses.last_batch as 连接当前时间,sysprocesses.status as 连接状态, sysprocesses.hostname as 服务器名称或ip, sysprocesses.loginame as sql登录名,sysprocesses.program_name as 执行sql名称,sysprocesses.dbid as 数据库id主表,

       SYSDATABASES.dbid as 数据库id子表,  SYSDATABASES.name as 数据库名称,  SYSDATABASES.filename as 数据库物理路径

from   sysprocesses left outer join SYSDATABASES on sysprocesses.dbid =  SYSDATABASES.dbid

where sysprocesses.loginame = 'kisadmin'