My Dynamics / Great Plains Connect Issue Gets A Response

I wrote almost a year ago about an issue I ran into with Dynamics / Great Plains. The program intentionally tries to select a non-existent column from various tables as a means to determine if the table exists. Back in the days of SQL 6.5, when the Great Plains code was written, a “table / […]

Yet Another Reason Why Dynamics / Great Plains Is Horrible

The database design for Dynamics / Great Plains is well known to be incredibly poor. Now I’ve run into another reason why the program sucks. As per best practices, I’ve got alerts set up on all my SQL Servers. One of these alerts is for severity 20 errors. I have a server that is host […]

SQL Requirements For Upgrading To Dynamics GP 2010

We recently upgraded our installation of Great Plains from version 10 to Dynamics GP 2010 and ran into some difficulties with the upgrade hanging. We’re using SQL 2008 R2 as our database back end. Let me first state that I was not involved in this upgrade and it was our vendor who was working with […]