How to find a Company Name from the Dynamics Great Plains (GP) Database

SQL database names are restricted to 5 characters by the Dynamics GP Company Creation utility so the SQL database names used in a Dynamics GP installation tend to be far less informative than the Dynamics Company Name, which appears in the drop down list during the company selection process at login.

If you only have access to the SQL Database it is unlikely that you will know which database corresponds to which Company.

The following query can be run on demand within SQL by the appropriate technical resource to list all Companies within the Dynamics DB:

SELECT 

INTERID 'Database',

CMPNYNAM 'Company_Name' 

FROM DYNAMICS..SY01500

This query will display a list of company databases and the corresponding company names, so when the Validis Connect asks for the database name for a particular company, mistakes can be avoided. See image the results of the query below.