Advanced Options Tab

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