In the Troubleshooting issues with a DexSQL log recipe of Chapter 10, Maintaining Dynamics GP 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, it adds a host of features and logging options to get more information for support.
To create a DexSQL log, perform the following steps:
In Microsoft Dynamics GP select Tools | Support Debugging Tool from the Microsoft Dynamics GP menu.
At the top of the screen, above Microsoft SQL Server Options, click on Turn On Manual Logging Mode.
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 Manual Logging Mode.
The
DexSQL.log
file now exists...