| title | allow updates Server Configuration Option | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/02/2017 | |
| ms.prod | sql | |
| ms.prod_service | database-engine | |
| ms.reviewer | ||
| ms.suite | sql | |
| ms.technology | configuration | |
| ms.tgt_pltfrm | ||
| ms.topic | conceptual | |
| helpviewer_keywords |
|
|
| ms.assetid | 3967c3ed-280a-4de8-a2ce-393e82745a7b | |
| caps.latest.revision | 32 | |
| author | MikeRayMSFT | |
| ms.author | mikeray | |
| manager | craigg |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]
This option is still present in the sp_configure stored procedure, although its functionality is unavailable in [!INCLUDEssNoVersion]. The setting has no effect. Direct updates to the system tables are not supported.
Important
[!INCLUDEssNoteDepFutureDontUse]
Changing the allow updates option will cause the RECONFIGURE statement to fail. Changes to the allow updates option should be removed from all scripts.