What Sql Express supports (and some things it doesn't)
I had a question come up regarding what is supported in Sql Express (specifically full-text search). I pulled this from the Books Online for Sql Express. It describes the features in Sql Express and what won't be in Sql Express.
SQL Server Express supports most of the features and functionality of SQL Server 2005. The following table lists some of the major features and components supported.
Stored Procedures |
SQL Computer 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 |
T-SQL language support |
Multiple Active Result Sets (MARS) |
Note: |
---|
SQL Server Express supports Service Broker applications, but direct communication between two SQL Server Express servers is not supported. |
The following list highlights the major SQL Server 2005 components that are not supported in this version of SQL Server Express:
- Reporting Services
- Notification Services
- Analysis Services
- Full text search
- DTS
- OLAP Services / Data Mining
- English Query
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.
New SQL Server 2005 features |
Existing SQL Server features |
---|---|
Dedicated Administrator Connection |
SqlMail and SQLiMail |
Database mirroring |
Fail-over clustering |
Online restore |
Distributed partitioned views |
Database snapshot |
VIA protocol support |
Parallel index operations |
Log shipping |
Mirrored media sets |
Parallel DBCC |
Scale up partitioning |
Parallel Create Index |
Address Windowing Extensions (AWE) |
Enhanced Read Ahead and Scan |
Hot-add memory |
Indexed views (materialized views) |
Native HTTP |
Partitioned views |