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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

User wants only to display only pdf as export option in report manager. How to achieve this?

173


Explain the various types of concurrency problem?

695


How is table type constraint applied to a table?

546


Differentiate between delete and truncate.

575


How to provide values to user defined function parameters?

553






Define union, union all, minus, intersect?

563


List the different types of joins?

566


What is cte (common table expression)?

593


Can we perform backup restore operation on tempdb? : sql server database administration

582


Write a sql query to sort on different column name according to the parameters passed in the function?

528


What are the differences between “row_number()”, “rank()” and “dense_rank()”?

535


What is built-in/administrator?

572


How to locate and take substrings with charindex() and substring() functions?

508


How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

663


In which tcp/ip port does sql server run? Can it be changed?

540