| title | Server Configuration: open objects | |
|---|---|---|
| description | Learn about the disabled configuration option open objects. See how SQL Server now manages the number of open database objects. | |
| author | rwestMSFT | |
| ms.author | randolphwest | |
| ms.date | 08/26/2025 | |
| ms.service | sql | |
| ms.subservice | configuration | |
| ms.topic | conceptual | |
| helpviewer_keywords |
|
[!INCLUDE SQL Server]
This option is still present in sp_configure, although its functionality has been disabled in [!INCLUDE ssNoVersion]. (The setting has no effect.) In [!INCLUDE ssNoVersion], 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
[!INCLUDE ssNoteDepFutureAvoid]