select * from sys.dm_exec_os_connections or select * from sys.dm

how can we know that how many users are connected in
perticuler server??????

Question Posted / rajesh kumar

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

Please Help Members By Posting Answers For Below Questions

Does sql server use t sql?

523

where can you add custom error messages to sql server? : Sql server administration

575

How can you ensure that the database and sql server based application perform well?

628

Explain the properties of sub-query in sql server?

503

Explain optimistic and pessimistic concurrency?

539

How do you use a subquery to find records that exist in one table and do not exist in another?

544

What is row_number () and partition by in sql server?

519

What is the fillfactor concept in indexes?

528

What is dirty read?

624

How do you trace the traffic hitting a sql server?

614

Define Wed Edition in SQL Azure?

Why use “pivot” in sql server?

619

Explain system rowset functions?

554

How do I delete a sql server database?

543

What is bcp? When does it used?

543