allow updates 服务器配置选项allow updates Server Configuration Option

适用对象:是SQL Server 否Azure SQL 数据库 否Azure Synapse Analytics (SQL DW) 否并行数据仓库APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

此选项仍然存在于 sp_configure 存储过程中,但是其功能在 SQL ServerSQL Server中不可用。This option is still present in the sp_configure stored procedure, although its functionality is unavailable in SQL ServerSQL Server. 其设置不起作用。The setting has no effect. 不支持直接更新系统表。Direct updates to the system tables are not supported.


后续版本的 Microsoft SQL Server 将删除该功能。This feature will be removed in a future version of Microsoft SQL Server. 请不要在新的开发工作中使用该功能,并尽快修改当前还在使用该功能的应用程序。Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

更改 allow updates 选项将导致 RECONFIGURE 语句失败。Changing the allow updates option will cause the RECONFIGURE statement to fail. 应当从所有脚本中删除对 allow updates 选项的更改。Changes to the allow updates option should be removed from all scripts.

另请参阅See Also

服务器配置选项 (SQL Server)Server Configuration Options (SQL Server)