Datasheet

Feature SQL Express Workgroup Standard Enterprise
Report Subscriptions ✓✓
Data-Drive Subscriptions ✓
Report Builder ✓✓✓
Report Manager ✓✓✓
Infinite Drill-down ✓
Notification Services ✓✓
SQL Server Integration
Services (SSIS)
✓✓✓
DBA Features by Edition
The DBA features have the largest disparity among editions. You can see in the following table that most
of the disparity revolves around high availability. If it’s of the utmost importance that your system
remain available all the time, use Enterprise Edition.
Feature SQL Express Workgroup Standard Enterprise
Indexed Views ✓✓✓✓
Indexing of XML Data Type ✓✓✓
Failover Clustering 2-node ✓
Number of Instances Supported 16 16 16 50
Log Shipping
✓✓✓
Database Snapshots ✓
Database Mirroring Primary Safety Full ✓
or Secondary Mode Only
Dedicated Administrator Connection
✓✓✓
Dynamic AWE ✓
Fast Start of the Instance ✓
Hot Memory Addition ✓
Online Indexing Operations ✓
Online Page and File Restoration ✓
Replication Subscriber ✓✓✓
Only
Table partitioning
✓
Updatable Partitioned Views ✓
15
SQL Server 2005 Architecture
04_055200 ch01.qxp 10/31/06 12:37 PM Page 15