January 4th, 2009
Great Plains Support on MSDE and SQL Express: crossing 2GB or 4GB limits
Historically Great Plains Software introduced Great Plains Select, which was available on Pervasive SQL 2000 and Ctree database platforms, not on Microsoft SQL Server. Later on, when Microsoft acquired Great Plains Software, it decided to switch from Pervasive and Ctree to newly introduced Microsoft SQL Server Desktop Edition or MSDE.
MSDE, which is scaled down Microsoft SQL Server 2000 placed
the limit on its database size to be 2GB.
Then in 2004, Microsoft Business Solutions came out with incentive to
allow Great Plains Standard 7.5 users to obtain registration key for running GP
on SQL Server 2000 platform free of charge.
If you are crossing 2GB DB limit on MSDN, you should consider the
following actions: