SQL Server Express Feature Support
SQL Server Express supports most of the features and functionality of SQL Server. The following table lists some of the major features and components that are supported.
|
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²
|
Import/Export Wizard
|
¹ SQL Server Express supports Service Broker, but direct communication between two SQL Server Express servers is not supported.
² The Dedicated Administrator Connection feature for SQL Server Express is supported with the trace flag 7806. For more information on trace flags and Dedicated Administrator Connection, and Using a Dedicated Administrator Connection in SQL Server Books Online.