Interested to Buy Any Domain ? << Click Here >> for more details...
How can u get the number of pupils connecting the database?
- 1 Answers
- 5583 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
How do I completely remove sql server instance?
What are drilldown reports?
What is the difference between mysql and mysqli?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
What are the differences between DDL, DML and DCL in SQL?
What is data modification?
Do you know data definition language, data control language and data manipulation language?
Explain DBCC?
What is reference section?
What is CTE in SQL
How to create a Master database in SQL server ?
What do you mean by subquery?
What are the advantages of user defined function?
What is purpose of normalization?
Can we write ddl in trigger?
