select * from sys.dm_exec_os_connections or select * from sys.dm

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

Question Posted / rajesh kumar

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

Please Help Members By Posting Answers For Below Questions

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

994

How to create a testing table with test data in ms sql server?

1084

Mention what are the core components of ssrs?

323

What are sub reports?

201

query processing

2175

What are the differences between lost updates and uncommitted dependencies?

1080

Does any body please help me what question's have asked for SSRS in the interview?

2148

How to add additional conditions in SQL?

1023

Describe the left outer join & right outer join. : sql server database administration

997

What happens if the update subquery returns multiple rows in ms sql server?

1125

What is the difference between dropping a database and taking a database offline?

1174

How can we call UDF(User Define Function) using C# code in ASP.net ?

6887

Does union all remove duplicates?

1067

What are three major types of constraints?

1120

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

1012