XploreDotNet
Known Is A Drop,UnKnown Is An Ocean....
Njoy Programming
Friday, November 20, 2009
How To Find The Number Of Live Connection In Database
SELECT
DB_NAME
(dbid) AS db,
COUNT
(dbid) AS connection
FROM
SYS.SYSPROCESSES
WHERE
dbid > 0
GROUP BY
dbid
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Loading...
No comments:
Post a Comment