Skip to content

Latest commit

 

History

History
37 lines (31 loc) · 1.37 KB

File metadata and controls

37 lines (31 loc) · 1.37 KB
title allow updates Server Configuration Option | Microsoft Docs
ms.custom
ms.date 03/02/2017
ms.prod sql-non-specified
ms.prod_service database-engine
ms.service
ms.component configure-windows
ms.reviewer
ms.suite sql
ms.technology
database-engine
ms.tgt_pltfrm
ms.topic article
helpviewer_keywords
allow updates option
ms.assetid 3967c3ed-280a-4de8-a2ce-393e82745a7b
caps.latest.revision 32
author BYHAM
ms.author rickbyh
manager jhubbard
ms.workload Inactive

allow updates Server Configuration Option

[!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.

See Also

Server Configuration Options (SQL Server)