Multiple choice technology databases

What is the command to get information about the currently running processes in SQL Server?

  1. sp_how

  2. sp_configure

  3. sp_who2

  4. sp_get_processinfo
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

sp_who2 is a system stored procedure in SQL Server that returns information about current users, sessions, and processes. It provides details like process ID, status, login name, hostname, and database context. sp_configure is for server settings, sp_how doesn't exist, and sp_get_processinfo is not a valid command.

Keep practicing — related questions