1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Post New Answer

More SQL Server Interview Questions

one table has four field id,name,design,salary. i have to find maximum salary .

6 Answers  

how many non clustered index in sql server 2008,2010,2012

2 Answers   Accenture,

What are the dmvs?

0 Answers  

What is use of @@ spid in sql server?

0 Answers  

How do I find the sql server version?

0 Answers  




How to use old values to define new values in update statements in ms sql server?

0 Answers  

Why truncate is ddl?

0 Answers  

what are acid properties? : Sql server database administration

0 Answers  

What is the process of indexing?

0 Answers  

What are the steps you must follow to hide sql server instances?

0 Answers  

What are the type of joins? When do we use Outer and Self joins?

3 Answers  

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories