Developing for Dynamics GP

by Microsoft Dynamics GP Developer Support Team (Fargo, ND, USA)

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

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

  • Comments 0

David Meego - Click for blog homepageMy 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.

Enjoy

David

Comments Information

PLEASE READ BEFORE POSTING

Please only post comments relating to the topic of this page.

If you wish to ask a technical question, please use the links in the links section (scroll down, on right hand side) to ask on the Newsgroups or Forums. If you ask on the Newsgroups or Forums, others in the community can respond and the answers are available for everyone in the future.

Leave a Comment
  • Please add 8 and 4 and type the answer here:
  • Post