Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
show open connections
--show open connections SELECT DB_NAME(dbid) as DBName, COUNT(dbid) as NumberOfConnections, loginame as LoginName FROM sys.sysprocesses WHERE dbid > 0 GROUP BY dbid, loginame SELECT COUNT(dbid) as TotalConnections FROM sys.sysprocesses WHERE dbid > 0 exec sp_who2 'Active'
run
|
edit
|
history
|
help
0
Branch
testing
Hack_this
Practice
VANYA
M0413045.sql
Libros
1
MindBoxTest
Manish_Sql_updated