Find Current
Users
Select login_name,COUNT(session_id)from sys.dm_exec_sessions group by login_name
Select login_name,COUNT(session_id)from sys.dm_exec_sessions group by login_name
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