Microsoft SQL Server 2005 Enterprise Edition |
|
Microsoft SQL Server 2005 Standard Edition |
|
Microsoft SQL Server 2005 Workgroup Edition |
|
Microsoft SQL Server 2005 Express Edition |
|
Microsoft SQL Server 2005 Developer Edition |
|
Microsoft SQL Server 2005 Mobile Edition |
|
Product Details
Data Management and Analysis Solution for Your Enterprise
- Faster Results

A new Management Studio and integration with Visual Studio 2005 and the Microsoft .NET common language runtime helps you build, debug, and operate applications faster and more efficiently.
- Better Decisions
A comprehensive business intelligence platform for data integration, analysis, and reporting that helps you turn insight into action and make better decisions, faster.
- Trusted Platform
The highest performance, availability and security to run your most demanding applications with native data encryption, secure default settings, and password policy enforcement.
What Is SQL Server 2005?
SQL Server 2005 is a comprehensive database platform providing enterprise-class data management with integrated business intelligence (BI) tools. The SQL Server 2005 database engine provides more secure, reliable storage for both relational and structured data, enabling you to build and manage highly available, performant data applications that you and your people can use to take your business to the next level.
The SQL Server 2005 data engine lies at the core of this enterprise data management solution. Additionally, SQL Server 2005 combines the best in analysis, reporting, integration, and notification. This enables your team to build and deploy cost-effective BI solutions with which they can drive data into every corner of your business through scorecards, dashboards, Web services, and mobile devices.
Close integration with Microsoft Visual Studio, the Microsoft Office System, and a suite of new development tools, including the Business Intelligence Development Studio, sets SQL Server 2005 apart. Whether you are a developer, database administrator, information worker, or decision maker, SQL Server 2005 provides innovative solutions that help you gain more value from your data.
The following diagram illustrates the core components in SQL Server 2005, showing how SQL Server 2005 is a key part of the Windows Server System in integrating with the Microsoft Windows platform—including the Microsoft Office System and Visual Studio—to offer solutions that deliver data to every corner of your organization.
Editions
Business today demands a different kind of data management solution—one that offers excellent performance, scalability, and reliability, but is also easy to use and maintain. Your business now expects more from its key information technology investments. SQL Server 2005 exceeds expectations by delivering enterprise-class data management and business intelligence.
The following list provides summaries and links to information about each edition of SQL Server 2005.
- SQL Server 2005 Enterprise Edition
Enterprise Edition includes the complete set of enterprise data management and business intelligence features. SQL Server Enterprise offers the highest levels of scalability and availability of all the SQL Server 2005 editions. Additionally, it is optimized to run on x64- and Itanium-based servers, helping you achieve higher levels of database scalability and availability.
- SQL Server 2005 Standard Edition
Standard Edition is an affordable option for small- and medium-sized organizations. It includes the core functionality needed for noncritical e-commerce, data warehousing, and line-of-business solutions. Standard Edition is optimized to run on win32, x64, and Itanium-based servers.
- SQL Server 2005 Workgroup Edition
Workgroup Edition is the data management solution for small organizations or workgroups within larger entities. It includes all the core database features needed for data management in an affordable and simple-to-manage package.
- SQL Server 2005 Express Edition
Express Edition helps developers build robust and reliable applications by providing a free, easy to use, and robust database when protecting and managing information inside and outside of applications is critical.
- SQL Server 2005 Developer Edition
Developer Edition is designed to enable developers to build any type of application on top of SQL Server 2005. It includes all the functionality of Enterprise Edition (win32, x64, IA64) but with a special development and test license agreement that prohibits production deployment.
- SQL Server 2005 Mobile Edition
Mobile Edition enables you to rapidly develop applications that extend enterprise data management and business intelligence capabilities to mobile devices.
MapPoint 2006 System Requirements
The recommended system configuration for Microsoft MapPoint version 2006 is a computer running Microsoft Windows XP Professional with a Pentium III processor and 128 megabytes (MB) of RAM. Below are the minimum requirements your computer needs to run MapPoint 2006. Some MapPoint features have additional requirements.
To use Microsoft® MapPoint 2006, you need:
- PC with Pentium II or higher processor; Pentium III recommended
- Microsoft® Windows® XP Home, Windows XP Professional, Windows ServerTM 2003, Windows 2000 Professional or later operating system required
- Microsoft Internet Explorer 5.5 browser software or later, Internet Explorer 6.0 SP1 included (will not displace your primary browser)
- For Windows XP Home and Windows XP Professional: 64 MB of RAM (128 MB recommended)
- For Windows Server 2003: 256 MB of RAM
- For Windows 2000 Professional: 64 MB of RAM (128 MB recommended)
- Running additional applications simultaneously may require additional memory
- Available hard-disk space: 1.1 GB for full installation or 500 MB for minimum installation. Some users may require up to an extra 100MB for System Files Update (hard disk usage will vary depending on configuration).
- 4x speed or faster CD-ROM drive
- Super VGA (800 x 600) or higher resolution monitor with 256 colors; a monitor with higher resolution and more colors recommended and required for Driving Guidance feature
- Microsoft Mouse, Microsoft IntelliMouse®, or compatible pointing device
Additional items or services required to use certain features:
- For Voice Output: Windows XP or higher and compatible soundcard
- Microsoft Exchange, Internet SMTP/POP3, IMAP4, or MAPI-compliant messaging software required to use Send To as attachment; Microsoft Outlook® 2000 or later required to use Send To as picture
- 14,400-baud or higher recommended
- Some Internet functionality may require Internet access and payment of a separate fee to an Internet service provider and local charges may apply
- GPS functionality requires a GPS device that supports NMEA 2.0 or later
- A free COM port below 20 required for GPS
- Pocket Streets:
- A Pocket PC running Microsoft Windows CE 3.0 or later with ActiveSync 3.7 API and 500KB available program memory required for installation of Pocket Streets. Installing map files requires additional memory, approximately 1MB per city map
- A Microsoft Windows powered Smartphone 2002 or Microsoft Windows Mobile 2003 Smartphone or later with ActiveSync 3.7 API and 350KB available program memory required for installation of Pocket Streets for Smartphone. Installing map files requires additional memory, approximately 1MB per city map.

As technology continues to drive change, 64-bit processing is reshaping the database industry by providing more performance for data-intensive applications. See how Microsoft meets your performance needs with 64-bit technology.
- SQL Server on a 64-bit Platform
SQL Server 64-bit helps you achieve higher levels of database scalability and availability with an enterprise-class database optimized to run on x64- and Itanium-based servers. The 64-bit features are available only on the Standard, Enterprise, and Developer editions of SQL Server 2005.
SQL Server 2005 Features Comparison
Notes: In the following table, the "Comments" column provides comments on the specified feature. Numbers next to check marks indicate footnotes that appear at the bottom of the page. SQL Server 2005 Developer Edition and Evaluation Edition are not listed in the tables. These editions have the same feature set as the Enterprise Edition; the only difference between these editions is the licensing policies.

Scalability and Performance |
Number of CPUs |
1 |
2 |
4 |
No Limit |
Includes support for multicore processors. |
RAM |
1 gigabyte (GB) |
3 GB |
Operating system maximum |
Operating system maximum |
Memory limited to maximum supported by operating system. |
64-bit Support |
Windows on Windows (WOW) |
WOW |

|

|

|
Database Size |
4 GB |
No Limit |
No Limit |
No Limit |

|
Partitioning |

|

|

|

|
Support for large-scale databases |
Parallel Index Operations |

|

|

|

|
Parallel processing of indexing operations |
Indexed Views |

|

|

|

|
Indexed view creation is supported in all editions. Indexed view matching by the query processor is supported only in Enterprise Edition. |
High Availability |
Database Mirroring |

|

|
1
|

|
Advanced high availability solution that includes fast failover and automatic client redirection |
Failover Clustering |

|

|
2
|

|

|
Backup Log-shipping |

|

|

|

|
Data backup and recovery solution |
Online System Changes |

|

|

|

|
Includes Hot Add Memory, dedicated administrative connection, and other online operations |
Online Indexing |

|

|

|

|

|
Online Restore |

|

|

|

|

|
Fast Recovery |

|

|

|

|
Database available when undo operations begin |
| 1 |
Single REDO thread and the safety setting is always on. |
| 2 |
Supports only two nodes. |
Manageability |
Auto Tuning |

|

|

|

|
Automatically tunes database for optimal performance. |
Profiler |
1
|
2
|

|

|

|
SQL Server Management Studio Express |
See Comments |

|

|

|
Easy-to-use graphical management tool available as a separate download or included with the SQL Server Express w/Advanced Services download |
Management Studio |

|

|

|

|
Full management platform for SQL Server; includes Business Intelligence (BI) Development Studio. |
Database Tuning Advisor |

|

|

|

|
Automatically suggests enhancements to your database architecture to improve performance. |
Serviceability Enhancements |

|

|

|

|
Dynamic management views and reporting enhancements. |
Full-text Search |
See comments |

|

|

|
Available for SQL Server Express in the SQL Server Express w/ Advanced Services download |
SQL Agent Job Scheduling Service |

|

|

|

|

|
| 1 |
This edition can be profiled from a Standard or Enterprise Edition of SQL Server 2005. |
| 2 |
This edition can be profiled from a Standard or Enterprise Edition of SQL Server 2005. |
Security |
Advanced Auditing, Authentication, and Authorization |

|

|

|

|

|
Data Encryption and Key Management |

|

|

|

|
Built-in data encryption for advanced data security. |
Integration with Microsoft Baseline Security Analyzer |

|

|

|

|
Scans your system to check for common security vulnerabilities. |
Integration with Microsoft Update |

|

|

|

|

|
Programmability |
Stored Procedures, Triggers, and Views |

|

|

|

|

|
T-SQL Enhancements |

|

|

|

|
Includes exception handing, recursive queries, and support for new data types. |
Common Language Runtime and .NET Integration |

|

|

|

|

|
User-defined Types |

|

|

|

|
Extend the server with your own custom data types. |
Native XML |

|

|

|

|
Includes XML indexing and full-text XML search. |
XQuery |

|

|

|

|

|
Notification Services |

|

|

|

|
Allows the building of advanced subscription and publication applications. |
Service Broker |
1
|

|

|

|

|
Integration and Interoperability |
Import/Export |

|

|

|

|

|
Integration Services with Basic Transforms |

|

|

|

|
Provides graphical extract, transform, and load (ETL) capabilities. |
Integration Services Advanced Transforms |

|

|

|

|
Includes data mining, text mining, and data cleansing. |
Merge Replication |
1
|
2
|

|

|

|
Transactional Replication |
3
|
4
|

|

|

|
Oracle Replication |

|

|

|

|
Transactional replication with an Oracle database as a publisher |
Web Services (HTTP Endpoints) |

|

|

|

|
Support for native Web services, Web Services Description Language (WSDL), and Web authentication |
| 1 |
Subscriber only. |
| 2 |
Publish to up to 25 subscribers. |
| 3 |
Subscriber only. |
| 4 |
Publish to up to five subscribers. |
Business Intelligence |
Report Server |
See Comments |

|

|

|
Report Server is available for SQL Server Express in the SQL Server Express with Advanced Services download. |
Report Builder |

|

|

|

|
End-user reporting tool |
Reporting Data Sources |
1

|

|

|

|

|
Scale Out Report Servers |

|

|

|

|

|
Data Driven Subscriptions |

|

|

|

|

|
Infinite Clickthrough |

|

|

|

|

|
Data Warehousing |

|

|

|

|

|
Star Query Optimization |

|

|

|

|

|
SQL Analytical Functions |

|

|

|

|

|
BI Development Studio |
See Comments
2 |
3
|

|

|
Integrated development environment for building and debugging data integration, OLAP, data mining, and reporting solutions. |
Enterprise Management Tools |

|

|

|

|
Integration with SQL Management Studio, SQL Server Profiler, SQL Server Agent, Backup/Restore. |
Native Support for Web Services
(Service Oriented Architectures) |
4
|
5
|

|

|
Allows access to data from any device. |
Analysis Services |

|

|

|

|
Powerful analytics and data mining capabilities. |
Unified Dimensional Model (UDM) |

|

|

|

|
Enterprise business data model enables fast, interactive, ad hoc analysis of large data sets. Builds smarter reports that leverage centralized business logic and key performance indicators (KPIs), as well as the performance of UDM. |
Business Analytics |

|
|