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

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  






Categories