How can u get the number of pupils connecting the database?
- 1 Answers
- 5175 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 trace files?
What part does database design plays a role in performance of an sql server-based application?
Write the syntax for stuff function in an sql server?
How can we use ConnectorJ JDBC Driver with MS SQL?
Explain magic tables in sql server?
Where sql server usernames and passwords are stored in a sql server?
What is truncate table?
What stored procedure would you use to view lock information?
Explain four layers of abstraction microsoft architectured?
Explain sub-query?
What is SQL Azure Firewall?
What is #temp and @table variable in SQL server?
When we should use and scope of @@identity?
How to connect a database with sql express.?
Differentiate between a primary key and a unique key.
