sri


{ City } hyd
< Country > india
* Profession * teamlead
User No # 56969
Total Questions Posted # 0
Total Answers Posted # 1

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 5
Users Marked my Answers as Wrong # 0
Questions / { sri }
Questions Answers Category Views Company eMail




Answers / { sri }

Question { Cap Gemini, 4854 }

How can u get the number of pupils connecting the database?


Answer

try this below query:

use
go
select db_name(dbid) as db, count(dbid) as connections from sys.sysprocesses where dbid > 0 group by dbid

Is This Answer Correct ?    5 Yes 0 No