Multiple choice technology databases

What is the command to view/change SQL Server level paramaters/properties?

  1. sp_helpserver

  2. sp_configure

  3. sp_helpdb

  4. sp_get_serverinfo
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

sp_configure is the correct system stored procedure to view and modify SQL Server-level configuration parameters and properties. It displays or changes server configuration options. sp_helpserver shows server information, sp_helpdb is for database details, and sp_get_serverinfo doesn't exist.

Keep practicing — related questions