What are the limitations of Microsoft SQL Server Express Editions?
Microsoft SQL Server Express has a maximum capacity of 10GB and memory (RAM) of 1GB. See below for more details.
Acctivate QuickBooks Inventory Management Software utilizes the Microsoft SQL Server database engine. Many companies are able to use the included, free Express Edition. Companies with a higher transaction volume or higher user count may be required to upgrade to the SQL Server Standard edition to increase performance and capacity.
SQL Server Express includes the following limitations on the database file size, plus memory and processor utilization limits.
- Database size of a max of 10GB
- Memory allocation for SQL Server of 1GB
- 1 CPU core
Note: Some older versions listed below are no longer supported by Acctivate. Please refer to our System Requirements for up-to-date list of supported versions.
View the complete comparison chart of all SQL Server Editions from Microsoft.
Please Note: Acctivate support can not advise on purchasing SQL standard. You should consult with a Microsoft certified sales rep to discuss your setup and needs. Acctivate support can not advise on CAL's, version questions, etc. SQL Standard is sold and distributed by Microsoft or an authorized reseller.