| title | open objects Server Configuration Option | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/02/2017 | |
| ms.prod | sql-server-2016 | |
| ms.reviewer | ||
| ms.suite | ||
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | article | |
| helpviewer_keywords |
|
|
| ms.assetid | c8424d3c-86ba-4cc5-bf0c-be4ce44bdd04 | |
| caps.latest.revision | 26 | |
| author | BYHAM | |
| ms.author | rickbyh | |
| manager | jhubbard | |
| ms.workload | Inactive |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
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
[!INCLUDEssNoteDepFutureDontUse]