In the Chapter 9 recipe, Troubleshooting issues with a DexSQL log, we looked at creating a DexSQL log file for use in troubleshooting. That recipe didn't require any special software, but it did take a lot of back and forth to limit the contents of the file to the specific process to be logged. The free Support Debugging Tool from Microsoft not only makes this much easier, but it also adds a host of features and logging options to get more information for support.
In Microsoft Dynamics GP select Tools | Support Debugging Tool from the Microsoft Dynamics GP menu.
In the center of the screen in the SQL Logging section, click on Turn On:
Select Financial from the Navigation Pane. Select General under Transactions.
Reopen the Support Debugging Tool window from the Windows Taskbar and click on Turn Off. The DexSQL log file now exists under the
Data
folder where Dynamics GP is installed.
That's it. That is the minimum...