How to Enable Logging for SQL Complete

How to Enable Logging for SQL Complete

Logging is a standard mechanism used in many software tools to capture detailed information about application behavior, errors, and performance issues. It is particularly useful when diagnosing problems that are difficult to reproduce or analyze in real time.

This article explains how to enable logging specifically for SQL Complete, an add-in for SQL Server Management Studio (SSMS). Enabling logging helps gather diagnostic data for technical support and is compatible with all supported SSMS versions, including those installed via the official ssms installer or the latest SSMS 21 download.

Steps to Enable Logging

1. Start Tracing
  1. On the main SSMS panel, navigate to: SQL Complete > Trace > Start Tracing
2. Reproduce the Issue
  1. Perform the actions that lead to the issue you are experiencing.
  2. This ensures that the trace log will capture relevant diagnostic data.
3. Stop Tracing
  1. On the SSMS panel, go to: SQL Complete > Trace > Stop Tracing
4. Send the Trace Log to Devart
  1. Navigate to: SQL Complete > Trace > Send Trace Log to Devart
5. Submit Your Information
  1. Enter your name, email address, and the ticket number provided in your support request (e.g., #12345).
Info
Notes

Logging is safe to use during normal sessions and does not noticeably affect performance. Make sure your SSMS installation, especially if installed using the SSMS 21 download or SSMS installer, is fully up to date for best compatibility with SQL Complete.

Trace logs play a key role in identifying root causes and enabling faster, more accurate support.