在登陆SQL时,使用 Windows 身份验证。 select nt_username,count(*) from master.dbo.sysprocesses where HOSTNAME=HOST_NAME() group by nt_username order by count(0) desc
楼主是用Windows 身份验证登陆的SQL Server吗?我这的是WIN2K系统。 select nt_username,count(*) from master.dbo.sysprocesses where HOSTNAME=HOST_NAME() group by nt_username order by count(0) desc 我这的结果是 ------------------------------------------- nt_username 无列名 Administrator 1 System 1
select nt_username,count(*)
from master.dbo.sysprocesses
where HOSTNAME=HOST_NAME()
group by nt_username
order by count(0) desc
select nt_username,count(*)
from master.dbo.sysprocesses
where HOSTNAME=HOST_NAME()
group by nt_username
order by count(0) desc
我这的结果是
-------------------------------------------
nt_username 无列名
Administrator 1
System 1