SQL Anywhere Studio Help
Adaptive Server Anywhere Help
Introduction to property sheets
Server property sheet
The database server options on this tab correspond to server options that can be reset while the server is running.
For more information, see sa_server_option system procedure.
The Options tab of the Server property sheet has the following components:
Current time Displays the current time. Click Refresh to update the Current Time. You can also press F5 to update the current time.
Quitting time You can type a time when the database server is to shut down. Use the same format as the current time, which is as follows:
YYYY-MM-DD HH:NN:SS.SS
Disable new connections Select this option to prevent other users from connecting to the database. The may be useful for some maintenance operations.
Enable request-level logging Select this option to record requests that the server processes to the log file. This option is primarily for troubleshooting purposes. Selecting Enable Request-level Logging enables the options below.
Log all requests All requests that the server processes are recorded to the log file.
Log SQL requests only Limits the types of requests recorded to the log file.
For a list of the SQL Statements that are logged when you select SQL Requests, see sa_server_option system procedure.
Log file name When you select Enable Request-level Logging, you must provide a log file name. You can also click Browse to locate the file.
For information about request-level logging, see -zr server option.
Remember the last statement executed on each connection Select this option to instruct the database server to capture the most recently-prepared SQL statement for each connection to a database on the server.
For more information, see -zl server option.