Free Tools

The following tools fall into two categories: SQL Management Utilities and GP Resource Utilities.

SQL Management Utilities:

• Database Manager
• Trace
• Query

GP Resource Utilities:

• Finder
• Resource Explorer
• View Wizard

In general, the utilities are all useful to consultants and power users who need to create reports or SmartLists, write SQL queries and updates, and find data in Dynamics GP.

The SQL Management Utilities provide much of functionality that is in SQL Server’s SQL Management Studio but do so from within Dynamics GP. These tools are particularly helpful in deployments where it is not easy to access the server but you require the ability to look at SQL tables and views, and to write SQL Queries.

The GP Resource Utilities help locating windows and tables that store specific information and assist in getting that data out in an easy to read format.