To access configuration options available on the Advanced Options tab, point to the Edit menu, and then click Options. Click the Advanced Options tab:
The information in the following table describes each of the options available on the Advanced Options tab:
Option |
Description |
SMTP server host |
Host name for your SMTP server. This is used to send outbound email messages, which is used by the built-in scheduler. |
SMTP user |
Often SMTP servers require users to login before relaying an outbound email. Specify your user id in this field. |
SMTP password |
Specify your SMTP password. |
SMTP Port |
TCP/IP port the SMTP server is listening on. This is typically 25 or 587. |
Security |
Specify if your SMTP Server requires SSL/TLS or STARTTLS. |
Sender name |
Outbound emails contain this value as the sender’s name. This is typically your name. |
Sender email |
Outbound emails contain this value as the sender’s email. This is typically your email address. |
Email recipients |
Specify the email address of the recipients who should get notifications when a scheduled task completes. |
Fetch BLOBs while browsing |
If selected, BLOB and CLOB data are fetched automatically while browsing data. |
Consider unique index as PK |
If selected, WinSQL treats a unique index as primary key if either one is not specified or the ODBC driver does not support this feature. |
Enable Quick Math |
If checked, Quick Math tip displays when you select more than one cell in the result grid that contains numeric values. The Quick Math tip displays the sum, maximum, minimum, and average values for the selected cells. |
Log queries and results |
If checked, WinSQL is log queries and their results in $DATA_FOLDER\logs directory. |
Enable drill-down results |
If checked, Drill-down results are enabled |