BUG: Documentation Error in SQL Server 7.0 Books Online for OPEN OBJECTS Default Value (262033)


The information in this article applies to:

  • Microsoft SQL Server 7.0
This article was previously published under Q262033
BUG #: 57431 (SQLBUG_70)

SYMPTOMS

The following statement is made in Microsoft SQL Server 7.0 Books Online, under the "Setting Configuration Options" (BOOKS\SQLBOL.CHM::/html/1_server_27.htm) topic:

Configuration OptionMinimumMaximumDefault
open objects (A, RR, SC)02147483647500


However, when you run the following command on SQL Server 7.0: 
sp_configure 'open objects'
you see the following:

nameminimummaximumconfig_valuerun_value
open objects0214748364700


The default value given for the open objects option in the preceding SQL Server Books Online topic is incorrect. The correct value is 0.

WORKAROUND

The default value for the open objects option in the "Server Options" (BOOKS\SQLBOL.CHM::/html/8_qd_03_4.htm) topic in SQL Server Books Online is correct:

Server OptionSET optionDatabase optionDefault setting
open objectsNoneNone0

STATUS

Microsoft has confirmed this to be a problem in SQL Server 7.0.
Modification Type:MajorLast Reviewed:10/16/2002
Keywords:kbBug kbdocerr KB262033
©2002 Microsoft Corporation. All rights reserved.