Earlier in this chapter, we looked at executing SQL code from a user's machine with the free Support Administrator Console from Microsoft. Another option to execute SQL code from a user's machine is with the Support Debugging Tool.
Microsoft makes the Support Debugging Tool available to users via Dynamics GP partners. The tool is free, you just have to ask.
An advantage of the Support Debugging Tool over the Support Administrator Console is that the Support Debugging Tool is integrated into Dynamics GP and Dynamics GP security. This means that the Support Debugging Tool can be safely installed on a user's machine and access to it restricted via GP security roles. Also, as several other recipes of this chapter have shown, the Support Debugging Tool does much more than run SQL code.
It does run SQL code quite well though, and in this recipe we will look at how to accomplish that.