--- title: "open objects Server Configuration Option | Microsoft Docs" description: 'Learn about the disabled configuration option "open objects." See how SQL Server now manages the number of open database objects.' ms.custom: "" ms.date: "03/02/2017" ms.prod: sql ms.prod_service: high-availability ms.reviewer: "" ms.technology: configuration ms.topic: conceptual helpviewer_keywords: - "open objects option" ms.assetid: c8424d3c-86ba-4cc5-bf0c-be4ce44bdd04 author: markingmyname ms.author: maghan --- # open objects Server Configuration Option [!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)] This option is still present in **sp_configure**, although its functionality has been disabled in [!INCLUDE[msCoName](../../includes/msconame-md.md)] [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)]. (The setting has no effect.) In [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)], 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[ssNoteDepFutureDontUse](../../includes/ssnotedepfuturedontuse-md.md)] ## See Also [Server Configuration Options (SQL Server)](../../database-engine/configure-windows/server-configuration-options-sql-server.md)