How to Enable Logging for SSMS Add-ins Without Built-in Logging

How to Enable Logging for SSMS Add-ins Without Built-in Logging

Logging is necessary to capture detailed information about failures and issues in the program. When it's difficult to identify, reproduce, or diagnose a problem, logging helps in performing a deeper investigation.

This guide applies to the following SSMS Add-ins that do not have built-in logging, with the exception of:

  • Source Control for SQL Server
  • Data Pump for SQL Server
  • SQL Complete

Applicable Add-ins:

  • dbForge Unit Test for SQL Server
  • dbForge Index Manager for SQL Server
  • dbForge Search for SQL Server
  • dbForge Monitor for SQL Server

Steps to Capture Logs:

  1. Reproduce the Issue in SSMS:

    • Open SQL Server Management Studio (SSMS) and reproduce the issue you're experiencing with the add-in.

  2. Locate the Log Files:

    • Navigate to the folder where the logs are stored:
      • %SystemDrive%\Users\%UserName%\AppData\Roaming\Devart\current_product\
      • Example: %SystemDrive%\Users\%UserName%\AppData\Roaming\Devart\dbForge Unit Test for SQL Server\

  3. Send the Log Files:

    • Locate the files named loader.log and SSMS.log in the folder.
    • Send us the log files with the latest date for further analysis.

    • Related Articles

    • How to Enable Logging for SQL Complete

      Logging is required to capture detailed information about failures and issues in the program. If reproducing or diagnosing a problem is difficult, logging helps in performing a deeper investigation. This guide applies to the following product: ...

    • How to Create a Dump File from Task Manager for SSMS and Integrated Add-ins

      In cases where SSMS (SQL Server Management Studio) or any integrated add-ins freeze or stop responding, a dump file can be generated for debugging purposes. This applies to both SSMS and the following dbForge add-ins for SQL Server: dbForge SQL ...

    • How to Enable Logging for Source Control and Data Pump for SQL Server

      Logging is essential for capturing detailed information about failures and issues in the program. If reproducing or diagnosing a problem is difficult, logging helps in providing a deeper investigation. This guide applies to the following products: ...

    • How to generate "dump_crash" for SSMS , including ADD-in Tools

      In case SSMS (SQL Server Management Studio) crashes, you can set up your system to automatically create a dump file for debugging purposes. Follow these steps to create the necessary registry keys. Steps to Configure Automatic Dump File Creation for ...

    • SQL Complete tabs (SSMS)

      You may change settings for your tabs layout using these settings: In case you need to create custom tab names, please use this tab: You may find more information with tutorials in our documentation: ...