Microsoft KB Archive/37629: Difference between revisions
From BetaArchive Wiki
(importing KB archive) |
m (X010 moved page Microsoft KB Archive/Q37629 to Microsoft KB Archive/37629 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/") |
(No difference)
| |
Latest revision as of 19:21, 12 August 2020
PRB: Resetting Configuration Parameters to Defaults ID Number: Q37629
1.00 1.11 4.20 OS/2
Summary:
SYMPTOMS The memory parameter of SQL Server was inadvertently set too high and cannot be reset because the SQL server will not come up.
RESOLUTION One method to reset the SQL Server configuration parameters is to reload the master database; however, the BLDMASTR utility -r option will reset the configuration parameters to the defaults without affecting the master database or user databases. The -d parameter must be used to specify the name of the MASTER.DAT file. If MASTER.DAT was originally case-insensitive, the -C option must also be specified.
Additional reference words: bldmastr case insensitive case-insensitive
