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

Explain the working of sql privileges?

1033

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1061

How can you check the level of fragmentation on a table?

985

How you can get a list of all the table constraints in a database?

906

what changed between the previous version of sql server and the current version? : Sql server database administration

955

What are the steps to process a single select statement?

887

What is normalization? Describe its different types.

1038

Where sql server usernames and passwords are stored in a sql server?

930

Explain about analysis services?

980

How to convert numeric expression data types by assignment operations?

1001

How to convert a unicode strings to non-unicode strings?

1028

What is forward - only cursors / read only cursor?

1019

How to run sql server 2005 books online on your local system?

916

How can I tell if sql server is 32 or 64 bit?

901

What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

135