The SQL Log and SQL Errors views both contain commands that enable you to save, restore, or otherwise move log entries into files outside of SQL Query Tuner. Additionally, both views also contain commands that enable the clearing of the view.
The current editor option will only show users statements as generated by the active editor.
To maintain log entries
All entries automatically captured by the Error Log are written to a file (.log suffix) that resides in the Workspace .metadata folder.
- Right-click in the SQL Log view and select Clear Log Viewer to remove all messages.
In the shortcut menu, select Delete Log to delete the .log file. If entries are created after the Delete Log command is issued, SQL Query Tuner will automatically generate a new .log file in the .metadata subfolder.
Old Error Log entries cannot be recovered once the .log file is deleted. To prevent data loss, archive the .log file via the Export command prior to deletion.
- To clear the Error Log view without deleting the .log file, select Clear Log Viewer from the shortcut menu. The View will be cleared of entries, but these entries will still be contained in the .log file.
- To restore the Error Log view based on the entries contained in the .log file, select Restore Log from the shortcut menu. The View is restored based on the entries in the .log file.