Log files collect information about the application while you are using it. These files are useful to us if you have encountered a problem.

To find the log files for the current session, open the SQL Prompt menu, click Help and then click Locate Log Files:

Log file locations

By default the log files are stored in:

• %LOCALAPPDATA%\Red Gate\Logs\SQL Prompt 10 (Windows Vista, Windows 2008 and later)
• %UserProfile%\Local Settings\Application Data\Red Gate\SQL Prompt 10 (Windows XP and Windows 2003)

Sending log files to Redgate support

If asked by Redgate support to send your log files, there is a menu item called Zip Log Files that can be used to collate all of the log files into a single zip file.

Verbose logging

If you're troubleshooting a problem, you can turn on verbose logging to see more information in the log files.

To do this, under SQL Prompt > Help, click Enable Verbose Logging.