Multiple choice technology databases

What command(s) you have to execute to know the processes running inside SQL server.

  1. Sp_helpdb

  2. sp_helpprocess

  3. sp_who2

  4. select * from sys.sysprocesses
Reveal answer Fill a bubble to check yourself
C,D Correct answer
Explanation

sp_who2 is a system stored procedure that returns information about current users, sessions, and processes in SQL Server. The query 'select * from sys.sysprocesses' directly accesses the system view containing process information. sp_helpdb shows database information, and sp_helpprocess is not a valid SQL Server stored procedure. Both C and D are valid methods.

Keep practicing — related questions