允許更新伺服器組態選項allow updates Server Configuration Option

適用於: 是SQL Server 否Azure SQL Database 否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)