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
5782 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

what is difference between Enterprise Manager and Query Analyer

6 Answers CTS,

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 exporting utility?

0 Answers

What are the underflow and overflow behaviors on float literals?

0 Answers

What is the use of nvl work?

0 Answers

please tell me the query to get details of the employee having the second largest salary

11 Answers 247Customer,

What is tabulation?

0 Answers

What is a recursive stored procedure in sql server?