開啟物件伺服器組態選項open objects 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

雖然在 中已停用此選項的功能,但此選項仍存在於 MicrosoftMicrosoft SQL ServerSQL Server.This option is still present in sp_configure, although its functionality has been disabled in MicrosoftMicrosoft SQL ServerSQL Server. (此設定無效)。在 SQL ServerSQL Server 中,已開啟之資料庫物件的數目會受到動態管理,而且只受可用記憶體的限制。(The setting has no effect.) In SQL ServerSQL Server, the number of open database objects is managed dynamically and is limited only by the available memory. open objects 選項可在 sp_configure 中使用,以保有與現有指令碼之間的回溯相容性。The open objects option available in sp_configure for backward compatibility with existing scripts.

重要

未來的 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.

另請參閱See Also

伺服器組態選項 (SQL Server)Server Configuration Options (SQL Server)