| title | Server Configuration: allow updates | |
|---|---|---|
| description | Learn about the obsolete SQL Server configuration option allow updates. See how using this option causes RECONFIGURE statements to fail. | |
| author | rwestMSFT | |
| ms.author | randolphwest | |
| ms.date | 08/26/2025 | |
| ms.service | sql | |
| ms.subservice | configuration | |
| ms.topic | conceptual | |
| helpviewer_keywords |
|
[!INCLUDE SQL Server]
This option is still present in the sp_configure stored procedure, although its functionality is unavailable in [!INCLUDE ssNoVersion]. The setting has no effect. Direct updates to the system tables aren't supported.
Important
[!INCLUDE ssNoteDepFutureAvoid]
Changing the allow updates option causes the RECONFIGURE statement to fail. Changes to the allow updates option should be removed from all scripts.