Whenever you make a change to your configuration values using sp_configure, Adaptive Server saves the old configuration file under the name servername.sequential_number. This means that your default configuration should exist in one of these files.
If you successfully locate the desired configuration file, do the following:
Name the current servername.cfg file to servername.cfg.old.
Rename the file you located to servername.cfg.
Restart Adaptive Server.
If you are unable to locate the desired configuration file, do the following:
Rename the servername.cfg file in your Sybase home directory to servername.cfg.old.
Start Adaptive Server without specifying a configuration file name.
Adaptive Server will use the default configuration and create a new configuration file if there is no servername.cfg file available at start-up time.
