34,591
社区成员
发帖
与我相关
我的任务
分享
declare @dbid int
set @dbid=db_id('數據庫名')
select distinct hostname,
db_name(dbid),
net_address, --物理地址
loginame,
program_name
from master..sysprocesses
where hostname='服務器名'and(@dbid is null or dbid=@dbid)
declare @dbid int
set @dbid=db_id('db_Stuey')
select distinct hostname,
db_name(dbid),
net_address,
loginame,
program_name
from master..sysprocesses
where hostname!=''and(@dbid is null or dbid=@dbid)