Logging SQL with the Support Debugging Tool and 10 Free Add-ons

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

My friend, Mariano Gomez aka The Dynamics GP Blogster has a couple of recent posts I would highlight.

In the first, Mariano discusses the Support Debugging Tool‘s ability turn on and off the DEXSQL.LOG SQL logging without having to exit the application or modify the DEX.INI.  Have a look at the post at Enabling DEXSQL logs with Support Debugging Tool.

A couple of additional points.  On a Terminal Server system with a shared DEX.INI file, this allows the DEXSQL.LOG to be enabled for a single user rather than all users on the system.  This means that the log will only contain the communication between the Dynamics GP application and SQL Server for that one user session.  You could also use Manual Logging Mode, which captures the DEXSQL.LOG as well as the Dexterity Script Log and Dexterity Script profile, all with a single button click or keypress (see Tools menu for keyboard shortcuts).

Note: The ability to change the file name of the DEXSQL.LOG works by renaming the file when logging stops.  It is not possible to change the file name used while it is recording the log.

In the second article, Mariano gives us his top 10 free add-ons to Microsoft Dynamics GP.  Included in his list are two of my tools, which is great, but also a number of other handy tools from other developers and consultants.  Please check out the post Top 10 Microsoft Dynamics GP freebies for more information.



This article was originally posted on the Developing for Dynamics GP Blog and has been reposted on http://www.winthropdc.com/blog.

One thought on “Logging SQL with the Support Debugging Tool and 10 Free Add-ons

Please post feedback or comments

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.