How to check active connections in sql server, SQL server active connections, SQL server connections, SQL server list active connections, SQL server view active connections
First you need to open the SSMS.
1. Start search SSMS.
2.Open the SQL Server management studio.
3.Then connect to the sql server you want check he number of connections
4. Open New Query window.
5.Copy and Paste the below select statement
DB_NAME(dbid) as DBName,
COUNT(dbid) as NumberOfConnections,
loginame as LoginName
dbid > 0