SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
| | Datacenter | Enterprise | Standard | Web | Workgroup | Express |
| Number of CPUs |
OS maximum |
8 |
4 |
4 |
2 |
1 |
| Maximum memory utilized |
OS maximum |
2 TB |
64 GB |
64 GB |
4 GB |
1 GB |
| Maximum database size |
524 PB |
524 PB |
524 PB |
524 PB |
524 PB |
10 GB |
| IA64 hardware support |
|
|
|
|
|
|
| Resource governor |
|
|
|
|
|
|
| Table and index partitioning |
|
|
|
|
|
|
| Parallel index operations |
|
|
|
|
|
|
| Parallel consistency checks (DBCC) |
|
|
|
|
|
|
| Enhanced read-ahead scan |
|
|
|
|
|
|
| Scalable shared databases |
|
|
|
|
|
|
| Indexed views |
|
|
|
|
|
|
| Distributed Partition Views |
|
|
|
|
|
| | Datacenter | Enterprise | Standard | Web | Workgroup | Express |
| Log shipping |
|
|
|
|
|
|
| Database mirroring2 |
|
|
Yes (single thread, synchronous only) |
Witness only |
Witness only |
Witness only |
| Automatic corruption recovery from mirror |
|
|
|
|
|
|
| Log stream compression |
|
|
|
|
|
|
| Number of Failover clustering nodes |
16 |
16 |
2 |
|
|
|
| Backup compression |
|
|
|
|
|
|
| Mirrored backups |
|
|
|
|
|
|
| Database snapshots |
|
|
|
|
|
|
| Fast recovery |
|
|
|
|
|
|
| Online indexing |
|
|
|
|
|
|
| Online page and file restore |
|
|
|
|
|
|
| Online configuration of Peer to Peer nodes |
|
|
|
|
|
|
| Hot add memory and CPU support |
|
|
|
|
|
| | Datacenter | Enterprise | Standard | Web | Workgroup | Express |
| Hypervisor support |
|
|
|
|
|
|
| Guest failover clustering support for virtualization |
|
|
|
|
|
|
| Hyper-V live migration |
|
|
|
|
|
|
| Application mobility |
|
|
|
|
|
| | Datacenter | Enterprise | Standard | Web | Workgroup | Express |
| Snapshot replication |
|
|
|
Subscriber only |
|
Subscriber only |
| Merge replication |
|
|
|
Subscriber only |
Restricted |
Subscriber only |
| Transactional replication |
|
|
|
Subscriber only |
Restricted |
Subscriber only |
| SQL Server change tracking |
|
|
|
|
|
|
| Publishing data from SQL Server to non SQL Server subscribers |
|
|
|
|
|
|
| Publishing data from Oracle to SQL Server |
|
|
|
|
|
|
| Peer to Peer replication |
|
|
|
|
|
| | Datacenter | Enterprise | Standard | Web | Workgroup | Express |
| Windows Integrated Authentication (including Kerberos) |
|
|
|
|
|
|
| Integration with Microsoft baseline security analyzer |
|
|
|
|
|
|
| C2 compliant audit mode1 |
|
|
|
|
|
|
| Common criteria compliance |
|
|
|
|
|
|
| Data encryption and key management |
|
|
|
|
|
|
| Module signing |
|
|
|
|
|
|
| Transport Layer Security channel encryption |
|
|
|
|
|
|
| Windows password policy support |
|
|
|
|
|
|
| User-schema separation |
|
|
|
|
|
|
| Login triggers and connection endpoints |
|
|
|
|
|
|
| Secure configuration through policy-based management |
|
|
|
|
|
|
| SQL Server audit (fine-grained auditing) |
|
|
|
|
|
|
| Transparent database encryption |
|
|
|
|
|
|
| Extensible key management |
|
|
|
|
|
| | Datacenter | Enterprise | Standard | Web | Workgroup | Express |
| Policy-Based Management |
|
|
|
|
|
|
| PowerShell support |
|
|
|
|
|
|
| SQL Server Management Object (SMO) |
|
|
|
|
|
|
| Sysprep support1 |
|
|
|
|
|
|
| SQL Server connection director |
|
|
|
|
|
|
| Dedicated admin connection |
|
|
|
|
|
Yes (Under trace flag) |
| Policy automation (check on schedule and change) |
|
|
|
|
|
|
| Maintenance plans |
|
|
|
|
|
|
| Database mail |
|
|
|
|
|
|
| Performance data collector |
|
|
|
|
|
|
| System Center Operations Manager Management Pack |
|
|
|
|
|
|
| Plan guides |
|
|
|
|
|
|
| User instances |
|
|
|
|
|
|
| | Datacenter | Enterprise | Standard | Web | Workgroup | Express |
| Support for data-tier application (DAC) operations - extract, deploy, upgrade |
|
|
|
|
|
|
| Able to enroll for multi-instance management. |
|
|
|
|
|
|
| Multi-instance dashboard views and drilldowns |
|
|
|
|
|
|
| Policy-based resource utilization evaluation |
|
|
|
|
|
| | Datacenter | Enterprise | Standard | Web | Workgroup | Express |
| SQL Server Configuration Manager |
|
|
|
|
|
|
| SQL CMD (command prompt tool) |
|
|
|
|
|
|
| SQL Server Migration Assistant1 |
|
|
|
|
|
|
| SQL Server Management Studio2 |
|
|
|
|
|
|
| SQL Server Agent |
|
|
|
|
|
|
| Database Engine Tuning Advisor |
|
|
|
|
|
|
| SQL Server Profiler |
|
|
|
|
|
|
| Analysis Services, PowerPivot IT operation dashboard |
|
|
|
|
|
| | Datacenter | Enterprise | Standard | Web | Workgroup | Express |
| Microsoft Visual Studio Integration |
|
|
|
|
|
|
| IntelliSense (Transact-SQL and MDX) |
|
|
|
|
|
|
| Business Intelligence Development Studio |
|
|
|
|
|
|
| SQL query, edit and design tools |
|
|
|
|
|
|
| Version control support |
|
|
|
|
|
|
| MDX edit, debug, and design tools |
|
|
|
|
|
| | Datacenter | Enterprise | Standard | Web | Workgroup | Express |
| Entity Framework support |
|
|
|
|
|
|
| Common language runtime (CLR) integration |
|
|
|
|
|
|
| Native XML support |
|
|
|
|
|
|
| XML indexing |
|
|
|
|
|
|
| MERGE and UPSERT capabilities |
|
|
|
|
|
|
| FILESTREAM support |
|
|
|
|
|
|
| Date and Time data types |
|
|
|
|
|
|
| Internationalization support |
|
|
|
|
|
|
| Full-text search |
|
|
|
|
|
|
| Specification of language in query |
|
|
|
|
|
|
| Service Broker (messaging) |
|
|
|
Client only |
|
Client only |
| XML/A support |
|
|
|
|
|
|
| Web services (HTTP/SOAP endpoints) |
|
|
|
|
|
|
| T-SQL endpoints |
|
|
|
|
|
| | Datacenter | Enterprise | Standard | Web | Workgroup | Express |
| Master Data Services database |
|
|
|
|
|
|
| Master Data Manager Web application |
|
|
|
|
|
|
| Master Data Services Web service |
|
|
|
|
|
http://www.microsoft.com/sqlserver/en/us/product-info/compare.aspx
SQLServer2008R2EditionsDatasheet_Aug10[1].pdf