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

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

Answer / sreenivas

try this below query:

use <databasename>
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

Post New Answer

More SQL Server Interview Questions

How to get the definition of a stored procedure back?

0 Answers  

how can you attach more than 20 ldf files in sql server

0 Answers   IBM,

What is sql server management studio? : sql server management studio

0 Answers  

What is excution Plan in sql server

1 Answers   TCS, CarrizalSoft Technologies,

What is the difference between local table and global table

1 Answers   Polaris, CarrizalSoft Technologies,

What is BCP? When does it used in sql server 2012?

0 Answers   TryTechnicals Pvt Ltd,

How do I determine how many instances of sql server are installed on a computer?

0 Answers  

What is sorting and what is the difference between sorting and clustered indexes?

1 Answers  

What are a scheduled jobs?

0 Answers  

To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

0 Answers  

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

0 Answers  

What is database isolation in sql server? : sql server database administration

0 Answers