There are times when the best way to confirm that information in Dynamics GP is correct is to simply look at the records in the SQL Server. Typically, this is done by executing an SQL command in SQL Server Management Studio. However, SQL Server Management Studio is not typically installed on an average user's machine. Also, the user's machine can be a long way from a computer with Management Studio installed. Finally, Management Studio contains a lot more features than is necessary to simply execute a query.
Microsoft again provides a free tool, this time in the form of the Support Administrator Console. Originally, this tool was designed for versions of Dynamics GP that ran on a light version of SQL Server that didn't include SQL Server Management Studio. Nevertheless, the Support Administrator Console works just fine with Dynamics GP 2010 and provides a lighter option in place of using SQL Server Management Studio for quick queries.
The...