SQL Server Features that Are Supported in SQL Server Express
SQL Server Express supports most of the features and functionality of SQL Server 2008. This includes 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
|
|
Snapshot isolation Levels
|
Service Broker (as a client only)¹
|
|
Native XML support. This includes 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³
|
Import/Export Wizard
|
¹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 2008 Express 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 2008 Books Online.
³For more information about the features that are supported in SQL Server Express with Advanced Services, see Reporting Services in SQL Server Express with Advanced Services.