Export (0) Print
Expand All

Features Supported by the Editions of SQL Server 2008

Use the following tables to determine which features are supported by the different editions of SQL Server 2008.

NoteNote

SQL Server Enterprise is available in an Evaluation edition for a 180-day trial period. For more information about how to obtain an evaluation copy of SQL Server 2008, see the SQL Server How to Buy Web site.

NoteNote

For features supported by SQL Server Evaluation and Developer, see the SQL Server Enterprise feature set. The features supported by SQL Server Enterprise, Developer, and Evaluation are the same.

Feature Name

Enterprise

Standard

Workgroup

Web

Express

Express Tools

Express Advanced

Partitioning

Yes

Data compression

Yes

Resource governor

Yes

Partition table parallelism

Yes

Feature Name

Enterprise

Standard

Workgroup

Web

Express

Express Tools

Express Advanced

Multi-instance support1

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Log shipping

Yes

Yes

Yes

Yes

Database mirroring2

Yes (full)

Yes (safety full only)

Witness only

Witness only

Witness only

Witness only

Witness only

Failover clustering

Operating system maximum3

2 nodes

Dynamic AWE

Yes

Yes

Failover without client configuration

Yes

Yes

Automatic corruption recovery from mirror

Yes

Yes

Database snapshots

Yes

Fast recovery

Yes

Online indexing

Yes

Online restore

Yes

Mirrored backups

Yes

Hot add memory

Yes

Online configuration of P2P nodes

Yes

Hot add CPU

Yes

Backup compression

Yes

1 SQL Server supports 50 instances on a stand-alone server for all SQL Server editions. SQL Server supports 25 instances on a failover cluster.

2Asynchronous database mirroring is supported only by SQL Server 2005 Enterprise Edition SP1 and later versions.

3Windows Server 2003 supports a maximum of 8 failover cluster nodes. Windows Server 2008 supports a maximum of 16 failover cluster nodes.

Feature Name

Enterprise

Standard

Workgroup

Web

Express

Express Tools

Express Advanced

C2 audit mode

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SQL Server auditing

Yes

Transparent database encryption

Yes

ISV encryption (off-box key management)

Yes

Feature Name

Enterprise

Standard

Workgroup

Web

Express

Express Tools

Express Advanced

Merge replication

Yes

Yes

Subscriber only¹

Subscriber only

Subscriber only

Subscriber only

Subscriber only

Transactional replication

Yes

Yes

Subscriber only¹

Subscriber only

Subscriber only

Subscriber only

Subscriber only

Snapshot replication

Yes

Yes

Subscriber only

Subscriber only

Subscriber only

Subscriber only

Subscriber only

SQL Server change tracking

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Heterogeneous subscribers

Yes

Yes

Oracle publishing

Yes

P2P transactional replication

Yes

¹If an instance of WorkGroup is used as a Publisher, it supports a maximum of 25 subscriptions to all merge publications, and five subscriptions to all transactional publications. It supports an unlimited number of subscriptions to snapshot publications.

Feature Name

Enterprise

Standard

Workgroup

Web

Express

Express Tools

Express Advanced

User instances

Yes

Yes

Yes

Dedicated admin connection

Yes

Yes

Yes

Yes

Yes (Under trace flag)

Yes (Under trace flag)

Yes (Under trace flag)

Policy-Based Management

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Policy-Based Management automation

Yes

Yes

Yes

Yes

Policy-Based Management best practices policies

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Performance data collection and warehouse

Yes

Yes

Yes

Yes

Standard performance reports

Yes

Yes

Plan guides

Yes

Yes

Plan freezing for plan guides

Yes

Yes

Distributed partitioned views

Yes

Partial. Distributed Partitioned Views are not updatable

Partial. Distributed Partitioned Views are not updatable

Partial. Distributed Partitioned Views are not updatable

Partial. Distributed Partitioned Views are not updatable

Partial. Distributed Partitioned Views are not updatable

Partial. Distributed Partitioned Views are not updatable

Parallel index operations

Yes

Automatic query-to-indexed-view matching

Yes

Parallel database backup checksum check

Yes

Database mail

Yes

Yes

Yes

Yes

SQL Server Migration Assistant1

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Maintenance plans

Yes

Yes

Yes

Yes

1For more information about SQL Server Migration Assistant, see Migrate to SQL Server on the SQL Server web site.

Feature Name

Enterprise

Standard

Workgroup

Web

Express

Express Tools

Express Advanced

SQL Server management objects (SMO)

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SQL Server Configuration Manager

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SQL CMD (command prompt tool)

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SQL Server Management Studio

Yes

Yes

Yes

Yes (Basic version)

Yes (Basic Version)

Yes (Basic version)

SQL Server Profiler

Yes

Yes

Yes

Yes

SQL Server Agent

Yes

Yes

Yes

Yes

Database Engine Tuning Advisor

Yes

Yes

Yes

Yes

Microsoft Operations Manager Pack

Yes

Yes

Yes

Yes

Feature Name

Enterprise

Standard

Workgroup

Web

Express

Express Tools

Express Advanced

Microsoft Visual Studio Integration

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SQL query and edit and design tools

Yes

Yes

Yes

IntelliSense (Transact-SQL and MDX)

Yes

Yes

Yes

No

(SSMS is not installed with this edition)

Yes

Yes

Version control support

Yes

Yes

Yes

Business Intelligence Development Studio

Yes

Yes

MDX edit, debug, and design tools

Yes

Yes

Feature Name

Enterprise

Standard

Workgroup

Web

Express

Express Tools

Express Advanced

Common language runtime (CLR) integration

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Native XML support

Yes

Yes

Yes

Yes

Yes

Yes

Yes

XML indexing

Yes

Yes

Yes

Yes

Yes

Yes

Yes

MERGE capabilities

Yes

Yes

Yes

Yes

Yes

Yes

Yes

FILESTREAM support

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Date and Time data types

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Internationalization support

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Full-text search

Yes

Yes

Yes

Yes

Yes

Specification of language in query

Yes

Yes

Yes

Yes

Yes

Service Broker (messaging)

Yes

Yes

Yes

Client only

Client only

Client only

Client only

XML/A support

Yes

Yes

Web services (HTTP/SOAP endpoints)

Yes

Yes

Feature Name

Enterprise

Standard

Workgroup

Web

Express

Express Tools

Express Advanced

Spatial indexes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Geodetic data type

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Advanced spatial libraries

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Standards-based spatial support

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SQL Server Standard or Enterprise is required to design and run Integration Services packages. The Integration Services features that are installed by Workgroup, Web, and Express are only for use by the SQL Server Import and Export Wizard.

Feature

Enterprise

Standard

Workgroup

Web

Express

Express Tools

Express Advanced

SQL Server Import and Export Wizard, and the basic Integration Services features required by the wizard

Yes

Yes

Yes

Yes

Yes

Yes

Yes

SSIS Designer including VSTA scripting

Yes

Yes

Integration Services service, wizards, and command prompt utilities

Yes

Yes

Basic tasks and transformations in addition to those used by the Import and Export Wizard

Yes

Yes

Log providers and logging

Yes

Yes

Data profiling tools

Yes

Yes

Additional sources and destinations:

Raw File source

XML source

DataReader destination

Raw File destination

Recordset destination

SQL Server Compact destination

SQL Server destination

Yes

Yes

Advanced sources, transformations, and destinations:

Data Mining Query transformation

Fuzzy Lookup and Fuzzy Grouping transformations

Term Extraction and Term Lookup transformations

Data Mining Model Training destination

Dimension Processing destination

Partition Processing destination

Yes

Feature Name

Enterprise

Standard

Workgroup

Web

Express

Express Tools

Express Advanced

Create cubes without a database

Yes

Yes

Auto-generate staging and data warehouse schema

Yes

Yes

Attribute relationship designer

Yes

Yes

Efficient aggregation designers

Yes

Yes

Feature Name

Enterprise

Standard

Workgroup

Web

Express

Express Tools

Express Advanced

Change data capture

Yes

Star join query optimization

Yes

Scalable read-only AS configuration

Yes

Proactive caching

Yes

Auto parallel partition processing

Yes

Partitioned cubes

Yes

Distributed partitioned cubes

Yes

Feature Name

Enterprise

Standard

Workgroup

Web

Express

Express Tools

Express Advanced

SQL Server Analysis Services service

Yes

Yes

SQL Server Analysis Services backup

Yes

Yes

General performance/scale improvements

Yes

Yes

Dimension, attribute relationship, aggregate, and cube design improvements

Yes

Yes

Personalization extensions

Yes

Yes

Financial aggregations

Yes

Custom rollups

Yes

Semi-additive measures

Yes

Writeback dimensions

Yes

Linked measures and dimensions

Yes

Binary and compressed XML transport

Yes

Yes

Account intelligence

Yes

Perspectives

Yes

Analysis Services shared, scalable databases

Yes

Feature Name

Enterprise

Standard

Workgroup

Web

Express

Express Tools

Express Advanced

Standard algorithms

Yes

Yes

Data mining tools: wizards, editors, query builders

Yes

Yes

Cross validation

Yes

Models on filtered subsets of mining structure data

Yes

Time series: custom blending between ARTXP and ARIMA models

Yes

Time series: prediction with new data

Yes

Unlimited concurrent data mining queries

Yes

Advanced configuration and tuning for algorithms

Yes

Algorithm plug-in API

Yes

Parallel model processing

Yes

Time series: cross-series prediction

Yes

Unlimited attributes for association rules

Yes

Sequence prediction

Yes

Multiple prediction targets for naïve Bayes, neural network, and logistic regression

Yes

Feature Name

Enterprise

Standard

Workgroup

Web

Express

Express Tools

Express Advanced

Report server

Yes

Yes

Yes

Yes

Yes

Report Designer

Yes

Yes

Yes

Yes

Yes

Report Manager

Yes

Yes

Yes

Yes (Report Manager)

Yes (Report Manager)

Role-based security

Yes

Yes

Yes (Fixed roles)

Yes (Fixed roles)

Yes (Fixed roles)

Ad-hoc reporting (Report builder)

Yes

Yes

Yes

Word export and enhanced text formatting

Yes

Yes

Yes

Yes

Yes

Enterprise-scale reporting engine

Yes

Yes

Yes

Yes

Yes

IIS-agnostic report deployment

Yes

Yes

Yes

Yes

Yes

Updated management tools

Yes

Yes

Yes

Yes

Yes

Report definition customization extension (RDCE)

Yes

Yes

Yes

Yes

Yes

SharePoint integration

Yes

Yes

Enhanced SSRS gauges and charting

Yes

Yes

Yes

Yes

Yes

Custom authentication

Yes

Yes

Yes

Yes

Export to Excel, PDF, and images

Yes

Yes

Yes

Yes

Yes

Remote and non-relational data source support

Yes

Yes

E-mail and file share delivery

Yes

Yes

Report history, scheduling, subscriptions, and caching

Yes

Yes

Data source, delivery, and rendering extensibility

Yes

Yes

Scale out (Web farms)

Yes

Infinite clickthrough

Yes

Data-driven subscriptions

Yes

Reporting Services memory limits

OS Maximum

OS Maximum

4 GB

4 GB

4 GB


 Stay Up to Date with SQL Server Install, and Upgrade information

For the latest downloads, articles, videos and troubleshooting information from Microsoft, as well as selected solutions from the community, visit the SQL Server Setup page

For automatic notification of these updates, subscribe to the RSS feeds available on the page.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft