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
5712 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 snapshot replication?

0 Answers

how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

9 Answers Deloitte, Lason,

How to copy the tables, schema and views from one sql server to another?

0 Answers

Explain the usage of floor function in sql server.

0 Answers

How do I view a stored procedure in sql server?

0 Answers

How do I install only the client tools of sql server 2000?

0 Answers

How to create new tables with "select ... Into" statements in ms sql server?

0 Answers

How can sql server instances be hidden?

0 Answers

how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

0 Answers

What are scalar functions?

0 Answers

What are Row versions of DataRow?

0 Answers

how to know description of a table in sqlserver 2000

8 Answers

For more SQL Server Interview Questions Click Here