Share via


SQL Server Express with Advanced Services Features

New: 14 April 2006

Microsoft SQL Server 2005 Express Edition with Advanced Services provides the following capabilities in addition to the features that are available in SQL Server 2005 Express Edition:

  • SQL Server Management Studio Express, a graphical management tool based on SQL Server Management Studio that makes it easy to manage and administer SQL Server Express databases
  • Reporting Services, an integrated report creation and design environment to create reports
  • Full-text Search, a powerful search engine for searching text-intensive data

SQL Server 2005 Features that Are Supported in SQL Server Express

SQL Server Express supports most of the features and functionality of SQL Server 2005, including the following:

Stored Procedures

SQL Server Configuration Manager

Views

Replication (as a subscriber only)

Triggers

Advanced Query Optimizer

Cursors

SMO/RMO

sqlcmd and osql utilities

Integration with Visual Studio 2005

Snapshot Isolation Levels

Service Broker (as a client only)¹

Native XML support, including XQuery and XML Schemas

SQL CLR

Transact-SQL language support

Multiple Active Result Sets (MARS)

Dedicated Administrator Connection²

Full text Search

Subset of Reporting Services features³

-

¹SQL Server Express supports Service Broker, but direct communication between two servers that are running SQL Server Express is not supported.

²The Dedicated Administrator Connection feature for SQL Server 2005 Express Edition is supported with the trace flag 7806. For more information about trace flags and Dedicated Administrator Connection, see the Trace Flags (Transact-SQL) and Using a Dedicated Administrator Connection topics in SQL Server 2005 Books Online.

³For more information about the features that are supported in SQL Server Express with Advanced Services, see Reporting Services in SQL Server 2005 Express Edition with Advanced Services.

SQL Server 2005 Features that Are Not Supported in SQL Server Express

The following table lists the additional SQL Server 2005 database features that are not supported in this version of SQL Server Express. It also lists database features from previous versions of SQL Server that are not supported.

SQL Server 2005 features not supported in SQL Server Express SQL Server features from previous versions not supported in SQL Server Express

Database mirroring

SQL Mail

Online restore

Failover clustering

Database snapshot

Distributed partitioned views

Parallel index operations

VIA protocol support

Mirrored media sets

Log shipping

Partitioning

Parallel DBCC

Address Windowing Extensions (AWE)

Parallel Create Index

Hot-add memory

Enhanced Read Ahead and Scan

Native HTTP SOAP access

Indexed views (materialized views)

SQL Mail and Database Mail

Partitioned views

Online Index Operations

-

SQL Server Agent and SQL Server Agent Service

-

The following major SQL Server 2005 components are not supported in SQL Server Express:

  • Notification Services
  • Integration Services (formerly Data Transformation Services)
  • Analysis Services
  • OLAP Services/Data Mining

See Also

Concepts

Reporting Services in SQL Server 2005 Express Edition with Advanced Services

Other Resources

Features Supported by the Editions of SQL Server 2005

Help and Information

Getting SQL Server 2005 Assistance