Using sp_configure with a configuration file  Using sp_configure to read or write the configuration file

Chapter 5: Setting Configuration Parameters

Naming tips for the configuration file

Each time you modify a configuration parameter with sp_configure, Adaptive Server creates a copy of the outdated configuration file, using the naming convention server_name.001, server_name.002, server_name.003...server_name.999.

To work with a configuration file with a name other than the default name, keeping the server_name part of the file name, include at least one alphabetic character in the extension. Alternatively, you can change the server_name to part of the file name. Doing this avoids confusion with the backup configuration files generated by Adaptive Server when you modify a parameter.





Copyright © 2005. Sybase Inc. All rights reserved. Using sp_configure to read or write the configuration file

View this book as PDF