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

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

More SQL Server Interview Questions

what is the difference between count(*) and count(1) ?

Can we have more than one NULL in a column having unique constraint?

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

what are batch in sql server?

Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.

Does server sql treat char as a variable-length or fixed-length column?

What type of locking occurs during the snapshot generation? : sql server replication

What is named query? : sql server analysis services, ssas

What is the difference between seek predicate and predicate?

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

How to get the number of affected rows?

Explain what is sql server english query?

For more SQL Server Interview Questions Click Here