| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | |
|---|---|---|---|---|---|---|---|---|---|
open objects (server configuration option) |
Learn about the disabled configuration option open objects. See how SQL Server now manages the number of open database objects. |
rwestMSFT |
randolphwest |
03/02/2017 |
sql |
configuration |
conceptual |
|
[!INCLUDE SQL Server]
This option is still present in sp_configure, although its functionality has been disabled in [!INCLUDEmsCoName] [!INCLUDEssNoVersion]. (The setting has no effect.) In [!INCLUDEssNoVersion], the number of open database objects is managed dynamically and is limited only by the available memory. The open objects option available in sp_configure for backward compatibility with existing scripts.
Important
[!INCLUDEssNoteDepFutureAvoid]