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

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

Question Posted / yudistara

2 Answers
5610 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / 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

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

Answer / vishnu

sp_who which is documented or sp_who2 which is similar but
technically not documented.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More SQL Server Interview Questions

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 Answers

What is meant by indexing?

0 Answers

What is difference between views and tables?

0 Answers

What is a partition function in sql server?

0 Answers

Can we move Resource database from one path to another? If yes,How can we?

1 Answers Wipro,

What is BCNF? How is it better than 2NF & 3NF?

0 Answers Essar,

What is onf in normalization form?