Setting logging levels from the registry editor

Please note the instructions in this article involve editing the registry. Serious problems might occur if you modify the registry incorrectly. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:

 

Purpose

For some Redgate tools you can set the logging levels to verbose from the registry.

This can be useful if you’re troubleshooting an issue that prevents the tool from opening.

Steps

Open the Registry Editor and navigate to:

  • HKEY_CURRENT_USER\Software\Red Gate

You’ll then need to navigate to a specific key relevant to the tool you wish to set the log level for.

If these aren’t present you can create them.

 SQL Compare and Data Compare:

  •  HKEY_CURRENT_USER\Software\Red Gate\SQL Tools UI\Logging

 SQL Data Generator:

  • HKEY_CURRENT_USER\Software\Red Gate\SQL Data Generator 3\Logging

 SQL Dependency Viewer:

  • HKEY_CURRENT_USER\Software\Red Gate\SQL Dependency Viewer 2\Logging

 SQL Multi Script:

  • HKEY_CURRENT_USER\Software\Red Gate\SQL Multi Script 1\Logging  

 

 Then edit the DWORD with the name Loglevel and assign the Hexadecimal value 7f (0x7F)

 Again this can be created if it is not already present.

 If you then open the relevant Redgate tool, verbose logs will be created.

Was this article helpful?

0 out of 0 found this helpful
Have more questions? Submit a request