DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 938199 - Last Review: September 3, 2013 - Revision: 1.0

INTRODUCTION

This article compares the following products:
  • Microsoft SQL Server 2005 Express Edition for Microsoft Office Outlook 2007 with Business Contact Manager
  • Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) for older versions of Outlook with Business Contact Manager.

More information

All versions of Outlook with Business Contact Manager use a stand-alone SQL Server service for primary data storage. Older versions of Outlook with Business Contact Manager use MSDE 2000. Outlook 2007 with Business Contact Manager uses the newer SQL Server 2005 Express Edition.

SQL Server 2005 Express Edition provides several advantages, such as larger database capacity. Additionally, multiple concurrent users can access the database without difficulty. The comparable features are outlined in the following table.

Comparison of SQL Server 2005 Express Edition and MSDE 2000
Collapse this tableExpand this table
SQL Server 2005 Express EditionMSDE 2000
Includes User Instance support.Does not include User Instance support.
Data Transformation Service (DTS) runtime is available in a separate download.DTS runtime is present.
Easy deployment because Microsoft Data Access Components (MDAC) is not part of the installation.MDAC is part of the installation.
Uses Microsoft Windows Installer only. Has good servicing story.Uses Windows Installer and MSM. Servicing of MSM is difficult.
Transactional replication, merge replication, and snapshot subscriber replication are supported. Merge and snapshot publications are supported, in addition to the replication subscription.
Robust setup user interface.Basic setup user interface.
No agent is present.Agent is present.
Supports Microsoft Windows 2000 SP4, Microsoft Windows XP SP1, and Microsoft Windows Server 2003. Supports Microsoft Windows 98, Microsoft Windows Millennium Edition, Windows 2000, Windows XP, Microsoft Windows NT 4.0, and Windows Server 2003.
Common language runtime support.No common language runtime support.
Graphical user interface (GUI) tools are available.No GUI tools are available.
Database size limit: 4 GBDatabase size limit: 2 GB
1 CPU, 1 GB RAM2 CPU, 2 GB RAM
No throttle * Workload throttle is enforced for five concurrent workloads.
Deep integration with Microsoft Visual Studio.Basic integration with Visual Studio.

* SQL Server 2005 Express Edition and SQL Server 2005 allow for multiple concurrent users to connect to the database. The number of concurrent users depends on the CPU and on the RAM on the computer that hosts the database.

Applies to
  • Microsoft Office Outlook 2007 with Business Contact Manager
Keywords: 
kbhowto kbexpertiseinter kbinfo KB938199
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support