Interested to Buy Any Domain ? << Click Here >> for more details...
How can u get the number of pupils connecting the database?
- 1 Answers
- 5689 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
What is sqlservr.exe - process - sql server (sqlex?press)?
What are the different types of stored procedures?
What is the function of inner join?
What is meant by indexing?
What is inner join in sql server joins?
Can we call future method from queueable?
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
What do you understand by a view?
what is sql server? : Sql server database administration
What is factless fact table? : sql server analysis services, ssas
What is the partitioning method?
Explain what is the use of custom fields in report?
How to filter records of table in SQL SERVER?
