| Microsoft Dynamics GP is SQL Server based | | | | 2. SQL Server Book online. Here you can |
| application, which opens its resources to SQL Server | | | | find the description to SQL based error message |
| DBA. Plus you should be aware about Great Plains | | | | 3. GPS_SQL_ERROR_CODES table in |
| Dynamics initial architecture, which is Great Plains | | | | Dynamics Database. Here you can find Dynamics |
| Dexterity, where first level of event viewing should | | | | GP Great Plains related errors and their causes if |
| occur, prior to diving to the SQL Server Performance | | | | documented in Descriptions |
| tuning and events log depth. In this small publication | | | | 4. Appealing to Microsoft Dynamics GP |
| we would like to review Dexterity level of monitors: | | | | Technical support. MBS tech support works by case |
| 1. Dex.ini file. If you got Great Plains | | | | schema, meaning that if you are current in GP annual |
| upgrade issues, or consistent error messages coming | | | | enhancement program and you have Deluxe plus |
| from GP user, which do not allow you to continue | | | | support with unlimited cases per year, you can enjoy |
| normal operation, you should locate Dex.ini file in | | | | free case-by-case support, please check your support |
| Dynamics GP (for version 10.0 in Data subfolder) and | | | | level with your Great Plains VAR or Microsoft |
| make the following changes | | | | Business Solutions directly. If you on budget annual |
| SQLLogSQLStmt=TRUE | | | | enhancement program, you will have discounted price |
| SQLLogODBCMessages=TRUE | | | | for each case and you should manage Microsoft |
| SQLLogAllODBCMessages=TRUE | | | | technicians to close the case only when case is |
| If you make these changes to Dex.ini file, Great Plains | | | | resolved to your satisfaction |
| User Workstation will create dexsql.log file in Dynamics | | | | 5. Getting Great Plains Technical support |
| GP folder. You should come to the point of getting | | | | from your Great Plains Reseller. Your Great Plains |
| error message or stacking situation in GP and then just | | | | Partner is likely more familiar with your Great Plains |
| copy this file to cut the bottom of it, where it logs the | | | | implementation, customization, integration, custom |
| problem description and in good like scenario the | | | | reporting, data conversion and modified reports. |
| reasons | | | | |