How to enable Debug Mode in Toad for SQL Server so that it creates a verbose log of all actions within the application. (4375343)

How to enable Debug Mode in Toad for SQL Server so that it creates a verbose log of all actions within the application.

How to enable Debug Mode in Toad for SQL Server so that it creates a verbose log of all actions within the application.

NA

Steps to enable Debug Mode logging in Toad for SQL Server:

1. Find your Toad Shortcut, perform a Copy on it, go to your Desktop location, and then Paste it there.

2. In the new copy of the Toad shortcut (rename it as well to i.e. Toad Debug Mode Shortcut), right-click it, and choose Properties.

3. In the 'Target' field, add the parameter:   /log=all   to the end, where X.x is the product version, so the full Target field would look like:

"C:\Program Files (x86)\Quest Software\Toad for SQL Server X.x\toad.exe" /log=all for the 32 bits version

OR

"C:\Program Files\Quest Software\Toad for SQL Server X.x\toad.exe" /log=all for the 64 bits version

Then click Apply, and then OK.

4. Now, using the modified Toad Shortcut, start Toad for SQL Server. Make your database connection(s), and then replicate the issue or error you are getting. Close Toad after you are done.

5. The log file will be called ‘Toad.log’.  You can find it in the application data directory:

Win 10 or 11:

C:\Users\Administrator\AppData\Roaming\Quest Software\Toad for SQL Server X.x

Where X.x is the product version