how can we know that how many users are connected in
perticuler server??????
Answers were Sorted based on User's Feedback
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 |
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 |
What is self join in sql server joins?
What are the recovery models for a database?
Whether the updations made to the views reflect the original records in the table
How to resolve the orphan use problem? : sql server security
How to delete existing rows in a table?
What is ms sql server reporting services?
What are the advantages of sql stored procedure?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
How to select some specific columns from a table in a query in ms sql server?
When do u use clustered index and non-clustered index?
Do you know what is similarity and difference between truncate and delete in sql?
Explain filtered indexes benefits?