查当前sql server当前用户

tutu

SELECT DB_NAME(dbid)AS ConnectedToDB,
hostname, program_name,loginame,
cpu, physical_io, memusage, login_time,
last_batch, [status]
FROM master.dbo.sysprocesses where db_name(dbid) like 'abc%'
ORDER BY dbid, login_time, last_batch
GO