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
User wants only to display only pdf as export option in report manager. How to achieve this?
Explain the various types of concurrency problem?
How is table type constraint applied to a table?
Differentiate between delete and truncate.
How to provide values to user defined function parameters?
Define union, union all, minus, intersect?
List the different types of joins?
What is cte (common table expression)?
Can we perform backup restore operation on tempdb? : sql server database administration
Write a sql query to sort on different column name according to the parameters passed in the function?
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
What is built-in/administrator?
How to locate and take substrings with charindex() and substring() functions?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
In which tcp/ip port does sql server run? Can it be changed?