How can u get the number of pupils connecting the database?
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 to retrieve field values using mssql_result()?
What do we have to check in database testing?
How to remove duplicate rows from table?
What happens if time-only values are provided as date and time literals?
What is the cartesian product of the table?
What stored by the master?
What are pages and extents? : SQL Server Architecture
how to invoke a trigger on demand? : Sql server database administration
Why we need to use secondry database file? though, we can do same work using primary database file also.
what are different types of raid configurations? : Sql server database administration
Explain features and concepts of analysis services?
How to maintain a fill factor in existing indexes?
What is delete query?
Tell me what is the significance of null value and why should we avoid permitting null values?
When you use @@error and try-catch?