how can we know that how many users are connected in
perticuler server??????
Answer Posted / rajesh kumar
select * from sys.dm_exec_os_connections
or
select * from sys.dm_exec_os_sessions
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration
What is the difference between join and inner join?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
What is database white box testing?
can a table be moved to different filegroup? : Sql server administration
what is a correlated sub-query? : Sql server database administration
What does Master database contains?
Can you tell me some of the common replication dmv's and their use? : sql server replication
Do you know what is a trace frag? Where do we use it?
Why union all is faster than union?
what are triggers? : Sql server database administration
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
Define inner join? Explain with an example?
What is the difference between online clustering and Offline clustering?
do you know how to configure db2 side of the application? : Sql server database administration