Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

open objects Option

This option is still present in sp_configure, although its functionality has been disabled in Microsoft SQL Server 2005 (the setting has no effect). In SQL Server 2005, the number of open database objects is managed dynamically and is only limited by the available memory. The open objects option has been left in SP_CONFIGURE in order to ensure backward compatibility with existing scripts.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft