Multiple choice technology databases

Which one is the parameter of SP_Configure

  1. allow updates to system tables

  2. locking

  3. Setup

  4. no of lock
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

sp_configure 'allow updates' was a valid configuration parameter in older SQL Server versions, controlling whether users could directly update system tables. This option has been deprecated and removed in modern SQL Server versions for security reasons. The other options (locking, Setup, no of lock) are not valid sp_configure parameter names.

Keep practicing — related questions