SELECT
DB_NAME(dbid) as DBName,
COUNT(dbid) as NumberOfConnections,
loginame as LoginName
FROM
sys.sysprocesses
WHERE
dbid > 0
GROUP BY
dbid, loginame
查SQL Connection數
意見
No Data.
Comment:
| *Nickname: | |
| E-mail: | |
| Blog URL: | |
#Nickname#
2013/5/3 上午 11:03:22
#CommentContent#
|
|
| *請輸入驗證碼: | |