select ????db_name(dbid)?as?[database?Name],? ????count(dbid)?as?[No?Of?Connections], ????loginame?as?[Login?Name] from ????sys.sysprocesses where ????dbid?>?0 group?by ????dbid,?loginame
? 版權聲明
文章版權歸作者所有,未經允許請勿轉載。
THE END
select ????db_name(dbid)?as?[database?Name],? ????count(dbid)?as?[No?Of?Connections], ????loginame?as?[Login?Name] from ????sys.sysprocesses where ????dbid?>?0 group?by ????dbid,?loginame