Interested to Buy Any Domain ? << Click Here >> for more details...
How can u get the number of pupils connecting the database?
- 1 Answers
- 5777 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 the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
what is the difference between Delete and Truncate command in SQL
Can we use having clause without group by?
How to find the version of sql server? : sql server database administration
What is multilevel indexing?
What is the difference between dropping a database and taking a database offline?
Where views are stored in sql server?
What is sql injection? How to protect against sql injection attack?
Explain the properties of the relational tables?
What is lookup override?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
How many types of local tables are there in sql server?
How sql server enhances scalability of the database system?
How to generate random numbers with the rand() function in ms sql server?
Is it possible to have clustered index on separate drive from original table location?
