Configuration Parameters
The following sections examine each of the SQL Server configuration parameters. The configuration parameters are in alphabetical order, except in special cases when the parameters have already been discussed, such as the memory configuration parameters. Additionally, the advanced options are reviewed separately from the standard options.
NOTE
For each SQL Server 2000 configuration parameter, the Minimum, Maximum, and Default values are listed in table format as well as the dynamic variable status.
allow updates
If the value of allow updates is set to 1, the SQL Server system tables can be modified. But do not set this configuration value to 1 unless told to do so by Microsoft Technical Support.
CAUTION
Directly updating ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
