SELECT DB_NAME(dbid) as DBName,
COUNT
(dbid) as NumberOfConnections,
loginame as LoginName
FROM
sys.sysprocesses
WHERE
dbid > 0
GROUP
BY dbid, loginame
Sharafat Sarker - SQL Server Database Admin,USA. Microsoft Certification ID : 8204884, Microsoft Certified IT Professional(MCITP), Microsoft Certified Technology Specialist(MCTS), Microsoft Certified Professional(MCP),Microsoft Technology Associate(MTA),Oracle Certified Associate(OCA),Certified Java Programmer.I am also Masters of IT Engineering Student in Virginia Tech. Here I want to share my working knowledge and experiences. Please feel free to contact: sarker9@vt.edu
No comments:
Post a Comment