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

can you implement data mining in SSRS?

148

How to rebuild master databse?

1077

how to create “alternate row colour”?

146

What are the new features of sql server 2008 r2 reporting service?

209

What is perspective, have you ever created perspective? : sql server analysis services, ssas

913

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

169

What is replication and database mirroring?

1047

What does COMMIT command do?

1059

What is sql server agent and what are the two modes of authentication in sql server?

1056

What is the use of sign function?

1118

What are the steps you can take to avoid “deadlocks”?

976

Do you know how to make remote connection in database?

963

What do you understand by hotfixes and patches in sql server?

989

What is multilevel indexing?

927

Explain the dirty pages?

998