How can u get the number of pupils connecting the database?
- 1 Answers
- 5841 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 are different types of constraints?
Does view occupy space?
What is subquery? Explain the properties of a subquery?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is a coalesce function?
Can we do dml on views?
Can one drop a column from a table?
What are wait types?
What are the different SQL Server Versions you have worked on?
What is a scheduled job or what is a scheduled task?
What is self contained sub query?
How to convert numeric expression data types using the cast() function?
Why use identity in sql server?
How to convert character strings into numeric values?
How efficient you are in oracle and SQL server?
