Sign Up
Login
ALLInterview.com
Categories
|
Companies
|
Placement Papers
|
Code Snippets
|
Certifications
|
Visa Questions
Post Questions
|
Post Answers
|
My Panel
|
Search
|
Topics
|
Errors
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
,
5177 }
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