Interested to Buy Any Domain ? << Click Here >> for more details...
How can u get the number of pupils connecting the database?
- 1 Answers
- 5624 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
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
Can group by be used without aggregate functions?
How many servers can we create in a single subscription?
Do you know what are various aggregate functions that are available?
How to convert binary strings into integers in ms sql server?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
What is sql server profiler?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
What are different types of data sources?
What happens if strings are casted into wrong code pages in ms sql server?
New concepts of sql server 2005 use in your project.
How to manipulate data from one table to another table ?
What are key constraints?
What does top operator do?
What stored by the model?
