Features Supported by the Editions of SQL Server 2005

SQL Server 2005 Books Online (November 2008)

Updated: 15 September 2007

Use the following tables to determine which features are supported by the various editions of Microsoft SQL Server 2005. For information about the advanced capabilities in SQL Server 2005 Enterprise Edition, see the Empowering Enterprise Solutions white paper.

SQL Server 2005 Database Engine Features

The following abbreviations represent SQL Server 2005 editions:

EE = SQL Server 2005 Enterprise Edition
DE = SQL Server 2005 Developer Edition
SE = SQL Server 2005 Standard Edition
WG = SQL Server 2005 Workgroup Edition
SSE = SQL Server 2005 Express Edition
SSEA = SQL Server 2005 Express Edition with Advanced Services

Features/Database Engine Enhancements	EE (32-bit) EE (64-bit) DE (32-bit) DE (64-bit)	SE (32-bit) SE (64-bit)	WG (32-bit)	SSE (32-bit)	SSEA (32-bit)
Programmability Features
Microsoft .NET Framework	Yes	Yes	No	No	No
Common language runtime integration	Yes	Yes	Yes	Yes	Yes
User-defined Aggregates	Yes	Yes	Yes	Yes	Yes
User-defined Data Types	Yes	Yes	Yes	Yes	Yes
User-defined Functions	Yes	Yes	Yes	Yes	Yes
SQL Server Managed Provider (managed data access)	Yes	Yes	Yes	Yes	Yes
DML/DDL Triggers	Yes	Yes	Yes	Yes	Yes
Logon Triggers	Yes5	Yes5	Yes5	Yes5	Yes5
Eventing	Yes	Yes	Yes	Yes	Yes
Vardecimal Storage Format	Yes5	No	No	No	No
Features/Database Engine Enhancements	EE (32-bit) EE (64-bit) DE (32-bit) DE (64-bit)	SE (32-bit) SE (64-bit)	WG (32-bit)	SSE (32-bit)	SSEA (32-bit)
Data Types
CLR User-defined Data Types	Yes	Yes	Yes	Yes	Yes
New XML Data Type	Yes	Yes	Yes	Yes	Yes
Features/Database Engine Enhancements	EE (32-bit) EE (64-bit) DE (32-bit) DE (64-bit)	SE (32-bit) SE (64-bit)	WG (32-bit)	SSE (32-bit)	SSEA (32-bit)
Transact-SQL Enhancements
Exception Handling	Yes	Yes	Yes	Yes	Yes
Extensions for Querying Support	Yes	Yes	Yes	Yes	Yes
FOR XML Enhancements	Yes	Yes	Yes	Yes	Yes
Intrinsics (String Function)	Yes	Yes	Yes	Yes	Yes
LOB Programming Model	Yes	Yes	Yes	Yes	Yes
New Analytic Functions (Ranking)	Yes	Yes	Yes	Yes	Yes
New Apply Operator (Relational Operator)	Yes	Yes	Yes	Yes	Yes
New Pivot and Unpivot Operators (Relational Operators)	Yes	Yes	Yes	Yes	Yes
Notification Support	Yes	Yes	Yes	Yes	Yes
Recursive Queries	Yes	Yes	Yes	Yes	Yes
Top Enhancements	Yes	Yes	Yes	Yes	Yes
Distributed Query	Yes	Yes	Yes	Yes	Yes
Features/Database Engine Enhancements	EE (32-bit) EE (64-bit) DE (32-bit) DE (64-bit)	SE (32-bit) SE (64-bit)	WG (32-bit)	SSE (32-bit)	SSEA (32-bit)
Full-Text Search Enhancements
Full-Text Linked Server Queries	Yes	Yes	Yes	No	Yes
Full-Text Search Across Multiple Columns	Yes	Yes	Yes	No	Yes
Specification of Language in Query	Yes	Yes	Yes	No	Yes
Service Broker	Yes	Yes	Yes	Yes4	Yes4
HTTP Support (Native HTTP)	Yes	Yes	Yes	No	No
Features/Database Engine Enhancements	EE (32-bit) EE (64-bit) DE (32-bit) DE (64-bit)	SE (32-bit) SE (64-bit)	WG (32-bit)	SSE (32-bit)	SSEA (32-bit)
Manageability Features
Backup and Restore of Full-text Catalogs	Yes	Yes	Yes	No	Yes
Full-text catalogs included in database attach/detach operations	Yes	Yes	Yes	No	Yes
Full-Text Search Upgrade	Yes	Yes	Yes	No	Yes
Query Against Views (Formerly Indexing of Views)	Yes	Yes	Yes	No	No
Indexing of XML Datatype	Yes	Yes	Yes	Yes	Yes
Index Performance Improvements (formerly Inline Gathering , MSSearch 3.0)	Yes	Yes	Yes	No	No
Parallel Service Security (formerly Security Context Change)	Yes	Yes	Yes	No	No
Rich Status Reporting	Yes	Yes	Yes	No	No
Features/Database Engine Enhancements	EE (32-bit) EE (64-bit) DE (32-bit) DE (64-bit)	SE (32-bit) SE (64-bit)	WG (32-bit)	SSE (32-bit)	SSEA (32-bit)
Security Features
All Permissions Grantable	Yes	Yes	Yes	Yes	Yes
Encryption	Yes	Yes	Yes	Yes	Yes
Fine-Grained Administration Rights	Yes	Yes	Yes	Yes	Yes
Integrated Security for SQL Authorization	Yes	Yes	Yes	Yes	Yes
Separation of Users and Schema	Yes	Yes	Yes	Yes	Yes
Common Criteria Compliance	Yes5	No	No	No	No
Features/Database Engine Enhancements	EE (32-bit) EE (64-bit) DE (32-bit) DE (64-bit)	SE (32-bit) SE (64-bit)	WG (32-bit)	SSE (32-bit)	SSEA (32-bit)
Availability Features (Database Failure and Redundancy)
Failover Clustering	Yes	2-node	No	No	No
Multi-Instance Support	50	16	16	16	16
Database Mirroring	Yes	Safety FULL only	No	No; can be used as a witness	No; can be used as a witness
Log Shipping	Yes	Yes	Yes	No	No
Database Snapshot	Yes	No	No	No	No
Features/Database Engine Enhancements	EE (32-bit) EE (64-bit) DE (32-bit) DE (64-bit)	SE (32-bit) SE (64-bit)	WG (32-bit)	SSE (32-bit)	SSEA (32-bit)
Database Maintenance Features
Data and Backup Checksum Integrity Checks	Yes	Yes	Yes	Yes	Yes
Dedicated Administrator Connection	Yes	Yes	Yes	Yes1	Yes1
Dynamic AWE	Yes	Yes	No	No	No
Database Available during Recovery Undo	Yes	No	No	No	No
Hot Add Memory2	Yes	No	No	No	No
Mirrored Backup Media	Yes	No	No	No	No
Online Index Operations	Yes	No	No	No	No
Page Restore	Yes	Yes	Yes	Yes	Yes
Online Page and File Restore	Yes	No	No	No	No
Parallel Index Operations	Yes	No	No	No	No
Features/Database Engine Enhancements	EE (32-bit) EE (64-bit) DE (32-bit) DE (64-bit)	SE (32-bit) SE (64-bit)	WG (32-bit)	SSE (32-bit)	SSEA (32-bit)
XML Features
XML Datatype	Yes	Yes	Yes	Yes	Yes
Xquery Support	Yes	Yes	Yes	Yes	Yes
XML Data Manipulation Language (XML DML)	Yes	Yes	Yes	Yes	Yes
XML Views	Yes	Yes	Yes	Yes	Yes
FOR XML Enhancements	Yes	Yes	Yes	Yes	Yes
XML Type System Support (XML Schema Support)	Yes	Yes	Yes	Yes	Yes
Features/Database Engine Enhancements	EE (32-bit) EE (64-bit) DE (32-bit) DE (64-bit)	SE (32-bit) SE (64-bit)	WG (32-bit)	SSE (32-bit)	SSEA (32-bit)
Scalability and Performance Features
Database Engine Tuning Advisor (Replaces Index Tuning Wizard)	Yes	Yes	Yes	No	No
Updateable Distributed Partitioned Views	Yes	No	No	No	No
Enhanced Read-ahead and Scan (Super Scan)	Yes	No	No	No	No
Indexed Views (Materialized Views)3	Yes	Yes	Yes	Yes	Yes
Multiple Active Result Sets (MARS)	Yes	Yes	Yes	Yes	Yes
Persisted Computed Columns	Yes	Yes	Yes	Yes	Yes
Queuing Support	Yes	Yes	Yes	Yes	Yes
Snapshot Isolation Level (Row-level Versioning)	Yes	Yes	Yes	Yes	Yes
Table and Index Partitioning	Yes	No	No	No	No
VIA Support	Yes	No	No	No	No
Parallel DBCC	Yes	No	No	No	No
Features/Database Engine Enhancements	EE (32-bit) EE (64-bit) DE (32-bit) DE (64-bit)	SE (32-bit) SE (64-bit)	WG (32-bit)	SSE (32-bit)	SSEA (32-bit)
International Features (Collation, Character Support, and Global Deployment)
Complex Script/Bi-directional Support	Yes	Yes	Yes	Yes	Yes
GB18030 Support	Yes	Yes	Yes	Yes	Yes
Surrogate Support	Yes	Yes	Yes	Yes	Yes
Language Pack	Yes	Yes	Yes	Yes	Yes

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

2This feature requires SQL Server 2005 Enterprise Edition and is only available for 64-bit SQL Server 2005, and for 32-bit SQL Server when AWE is enabled.

3This feature is supported in all editions of SQL Server 2005, except that indexed view-to-query matching by the Query Optimizer is supported only in Enterprise Edition and Developer Edition. Indexed views can be created in all editions of SQL Server 2005, and queried by name using the NOEXPAND hint.

4 SQL Server Express or SQL Server Express with Advanced Services can exchange Service Broker messages with other editions of SQL Server. Messages between two instances of SQL Server Express or SQL Server Express with Advanced Services must be routed through another edition of SQL Server. For example, SQL Server Standard Edition or SQL Server Enterprise Edition.

5This feature is available in SQL Server 2005 SP2 and later versions.

SQL Server 2005 Management Tools Features

The following abbreviations represent SQL Server 2005 editions:

EE = SQL Server 2005 Enterprise Edition
DE = SQL Server 2005 Developer Edition
SE = SQL Server 2005 Standard Edition
WG = SQL Server 2005 Workgroup Edition
SSE = SQL Server 2005 Express Edition
SSEA = SQL Server 2005 Express Edition with Advanced Services

Features/Management Tools Enhancements	EE (32-bit) DE (32-bit) EE (64-bit) DE (64-bit)	SE (32-bit)	WG (32-bit)	SE (64-bit)	SSE (32-bit)	SSEA (32-bit)
Programmability Features
Design Tools Enhancements
Query Designer	Yes	Yes	Yes	No	No	No
Query Editor	Yes	Yes	Yes	No	No	No
MDX Query Editor	Yes	Yes	Yes	No	No	No
MDX IntelliSense	Yes	Yes	Yes	No	No	No
Transact-SQL IntelliSense	Yes	Yes	Yes	No	No	No
Version Control Support	Yes	Yes	Yes	No	No	No
XML/A	Yes	Yes	Yes	No	No	No
Features/Management Tools Enhancements	EE (32-bit) DE (32-bit) EE (64-bit) DE (64-bit)	SE (32-bit)	WG (32-bit)	SE (64-bit)	SSE (32-bit)	SSEA (32-bit)
Management Programming
SQL Server Management Objects (SMO)	Yes	Yes	Yes	No	Yes	Yes
WMI Configuration Provider	Yes	Yes	Yes	No	No	No
Manageability Features
Configuration
SQL Server Configuration Manager, MMC Snap-in	Yes	Yes	Yes	Yes	Yes	Yes
Features/Management Tools Enhancements	EE (32-bit) DE (32-bit) EE (64-bit) DE (64-bit)	SE (32-bit)	WG (32-bit)	SE (64-bit)	SSE (32-bit)	SSEA (32-bit)
Management
Microsoft Visual Studio Integration	Yes	Yes	Yes	Yes	Yes	Yes
New Dialog Style (Fully Scriptable and Schedulable User Interface)	Yes	Yes	Yes	No	No	No
SQL Server Management Studio	Yes	Yes	Yes	Yes	No	SQL Server Management Studio Express (a subset of SQL Server Management Studio)
Master Server	Yes (automatic)	Yes (manual)	No	No	No	No
Target Server	Yes	Yes	Yes	No	No	No
Features/Management Tools Enhancements	EE (32-bit) DE (32-bit) EE (64-bit) DE (64-bit)	SE (32-bit)	WG (32-bit)	SE (64-bit)	SSE (32-bit)	SSEA (32-bit)
Operations
Microsoft Operations Manager pack for SQL Server 2005	Yes	Yes	Yes	Yes	No	No
SQLCMD Command Prompt Tools (formerly OLESQL)	Yes	Yes	Yes	Yes	Yes	Yes
SQL Server Agent Job Reuse	Yes	Yes	Yes	Yes	No	No
SQL Server Agent Performance Counters	Yes	Yes	Yes	Yes	No	No
SQL Server Agent Scheduling	Yes	Yes	Yes	Yes	No	No
SQL Server Agent Security	Yes	Yes	Yes	Yes	No	No
SQL Server Agent Subsystems for OLAP and SSIS	Yes	Yes	Yes	Yes	No	No
SQL Server Agent	Yes	Yes	Yes	Yes	No	No
Web Assistant	Yes	Yes	Yes	Yes	No	No
SQL Mail	Yes on 32-bit No on 64-bit	Yes	Yes	No	No	No
Database Mail	Yes on 32-bit No on 64-bit	Yes	Yes	No	No	No
Features/Management Tools Enhancements	EE (32-bit) DE (32-bit) EE (64-bit) DE (64-bit)	SE (32-bit)	WG (32-bit)	SE (64-bit)	SSE (32-bit)	SSEA (32-bit)
Scalability and Performance
Database Engine Tuning Advisor	Yes	Yes	Yes	Yes	No	No
Performance Counter Correlation	Yes	Yes	Yes	Yes	No	No
SQL Server Profiler Enhancements	Yes	Yes	Yes	Yes	No	No
Profiling Analysis Services	Yes	Yes	Yes	Yes	No	No
Exportable Showplan and Deadlock Traces	Yes	Yes	Yes	Yes	No	No
Features/Management Tools Enhancements	EE (32-bit) DE (32-bit) EE (64-bit) DE (64-bit)	SE (32-bit)	WG (32-bit)	SE (64-bit)	SSE (32-bit)	SSEA (32-bit)
International Features (Collation, Character Support, and Global Deployment)
Complex Script/ Bi-directional Support	Yes	Yes	Yes	Yes	Yes	Yes
GB18030 Support	Yes	Yes	Yes	Yes	Yes	Yes
Surrogate Support	Yes	Yes	Yes	Yes	Yes	Yes

SQL Server 2005 Analysis Services Features

The following abbreviations represent SQL Server 2005 editions:

EE = SQL Server 2005 Enterprise Edition
DE = SQL Server 2005 Developer Edition
SE = SQL Server 2005 Standard Edition
WG = SQL Server 2005 Workgroup Edition
SSE = SQL Server 2005 Express Edition
SSEA = SQL Server 2005 Express Edition with Advanced Services

Features/Analysis Services Enhancements	EE (32-bit) DE (32-bit) EE (64-bit) DE (64-bit)	SE (32-bit)	WG (32-bit)	SSE (32-bit) SSEA (32-bit)	SE (64-bit)
Programmability Features
.NET Framework	Yes	Yes	No	No	Yes
.NET Stored Procedures	Yes	Yes	Yes	Yes	Yes
Cross Platform, Zero Footprint Client Access	Yes	Yes	No	No	Yes
Native XML Web services	Yes	Yes	No	No	Yes
HTTP access	Yes	Yes	No	No	Yes
Binary and compressed XML transport	Yes	No	No	No	No
Manageability Features
Auto Referential Integrity Handling	Yes	Yes	No	No	Yes
Capture and Replay	Yes	Yes	No	No	Yes
Fine-Grain Administration Rights	Yes	Yes	No	No	Yes
Profiler	Yes	Yes	No	No	Yes
Trace	Yes	Yes	No	No	Yes
Flight Recorder	Yes	Yes	No	No	Yes
Features/Analysis Services Enhancements	EE (32-bit) DE (32-bit) EE (64-bit) DE (64-bit)	SE (32-bit)	WG (32-bit)	SSE (32-bit) SSEA (32-bit)	SE (64-bit)
Management Programming Features
Analysis Management Objects (AMO and DMO)	Yes	Yes	No	No	Yes
Availability Features
Enhanced Backup and Restore	Yes	Yes	No	No	Yes
Failover Clustering	Yes	Yes	No	No	Yes
Multi-Instances	50	16	No	No	16
Server Synchs	Yes	Yes	No	No	Yes
Features/Analysis Services Enhancements	EE (32-bit) DE (32-bit) EE (64-bit) DE (64-bit)	SE (32-bit)	WG (32-bit)	SSE (32-bit) SSEA (32-bit)	SE (64-bit)
Business Intelligence Features
Auto Packaging and Deployment	Yes	Yes	No	No	Yes
Business Intelligence Wizard	Yes	Yes	No	No	Yes
Data Source Views Management	Yes	Yes	No	No	Yes
Integrated Business Intelligence Development Studio	Yes	Yes	No	No	Yes
Autobuild Builder Technology	Yes	Yes	No	No	Yes
MDX Debugger	Yes	Yes	No	No	Yes
Multi-Partition Editor	Yes	Yes	No	No	Yes
Source Control and Versioning	Yes	Yes	No	No	Yes
Unified Calculation Editor	Yes	Yes	No	No	Yes
Features/Analysis Services Enhancements	EE (32-bit) DE (32-bit) EE (64-bit) DE (64-bit)	SE (32-bit)	WG (32-bit)	SSE (32-bit) SSEA (32-bit)	SE (64-bit)
Data Mining Features
Enhanced Integrated OLAP and Data Mining Functionality (MDX Prediction function, DM dimensions)	Yes	Yes	No	No	Yes
Parallelism for model processing	Yes	No	No	No	No
Parallelism for model prediction	Yes	No	No	No	No
Text-Mining Term Extraction Transformation (SSIS)	Yes	No	No	No	No
Text-Mining Term Lookup Transform (SSIS)	Yes	No	No	No	No
Data Mining Query Transformation (SSIS)	Yes	No	No	No	No
Data Mining Processing Destination (SSIS)	Yes	No	No	No	No
Algorithm Plug-in API	Yes	No	No	No	No
Algorithm Viewers	Yes	Yes	No	No	Yes
Data Mining Tools (including Wizards, Editors, Query Builders, Lift Chart)	Yes	Yes	No	No	Yes
Standard Data Mining Algorithms	Yes	Yes	No	No	Yes
Advanced configuration and tuning options for Data Mining algorithms	Yes	No	No	No	No
Reporting Integration with DM Prediction Queries	Yes	Yes	No	No	Yes
Features/Analysis Services Enhancements	EE (32-bit) DE (32-bit) EE (64-bit) DE (64-bit)	SE (32-bit)	WG (32-bit)	SSE (32-bit) SSEA (32-bit)	SE (64-bit)
Advanced Analytic Features
Account Intelligence	Yes	No	No	No	No
Cross-database/cross-server linked measures and dimensions	Yes	No	No	No	No
Metadata translations	Yes	No	No	No	No
Perspectives	Yes	No	No	No	No
Semi-additive Measures	Yes	No	No	No	No
Writeback Dimensions	Yes	No	No	No	No
Features/Analysis Services Enhancements	EE (32-bit) DE (32-bit) EE (64-bit) DE (64-bit)	SE (32-bit)	WG (32-bit)	SSE (32-bit) SSEA (32-bit)	SE (64-bit)
Data Warehouse Building Features
Create cubes without database	Yes	Yes	No	No	No
Auto-generate Staging and Data Warehouse Schema	Yes	Yes	No	No	No
Auto-generate DTS Packages for Updating Data Warehouse Data	Yes	Yes	No	No	No
Extended Dimensional Modeling Features
Measure expressions	Yes	No	No	No	No
Scalability and Performance Features
Proactive Caching	Yes	No	No	No	No
Auto Parallel Partition Processing	Yes	No	No	No	No
Partitioned Cubes	Yes	No	No	No	No
Distributed Partitioned Cubes	Yes	No	No	No	No

1In SQL Server Standard Edition, you can have a maximum of 5000 attributes in any single column in a data mining model. This limitation also applies to values in nested tables. For more information, see article ID 932609 in the Microsoft Knowledge Base.

SQL Server 2005 Reporting Services Features

The following abbreviations represent SQL Server 2005 editions:

EE = SQL Server 2005 Enterprise Edition
DE = SQL Server 2005 Developer Edition
SE = SQL Server 2005 Standard Edition
WG = SQL Server 2005 Workgroup Edition
SSE = SQL Server 2005 Express Edition
SSEA = SQL Server 2005 Express Edition with Advanced Services

Features/Reporting Services Enhancements	EE (32-bit) DE (32-bit) EE (64-bit) DE (64-bit)	SE (32-bit) SE (64-bit)	WG (32-bit)	SSE (32-bit)	SSEA (32-bit)
Support for remote and nonrelational data sources	Yes	Yes	No	No	No
DHTML, Excel, PDF, and Image rendering extensions	Yes	Yes	Yes	No	Yes
MHTML, CSV, XML, and Null rendering extensions	Yes	Yes	No	No	No
E-mail and file share delivery extensions	Yes	Yes	No	No	No
Custom data processing, delivery, and rendering extensions	Yes	Yes	No	No	No
Custom report items	Yes	Yes	No	No	No
Custom authentication extensions	Yes	Yes	Yes	No	No
Report caching	Yes	Yes	No	No	No
Report history	Yes	Yes	No	No	No
Scheduling	Yes	Yes	No	No	No
Subscriptions	Yes	Yes	No	No	No
Data-driven subscriptions	Yes	No	No	No	No
User-defined role definitions	Yes	Yes	No	No	No
Report model data sources	Yes	Yes	Yes	No	No
Report model item security	Yes	Yes	No	No	No
Support for infinite clickthrough in ad hoc reports	Yes	No	No	No	No
Report Builder	Yes	Yes	Yes	No	No
Report Manager	Yes	Yes	Yes	No	Yes
SQL Server Management Studio	Yes	Yes	Yes	No	No
Report Designer in Business Intelligence Development Studio	Yes	Yes	Yes	No	Yes¹
Report server scale-out deployment	Yes	No	No	No	No

For information on additional Reporting Services features available in SQL Server 2005, see "Reporting Services Features" in SQL Server 2005 Books Online.

¹ Business Intelligence Development Studio is installed by using SQL Server 2005 Express Edition Toolkit. For more information, see SQL Server Express Toolkit in SQL Server 2005 Express Edition Books Online.

 In the Workgroup Edition and Express Edition with Advanced Services, Reporting Services only supports relational databases on the local Database Engine instance.

SQL Server 2005 Notification Services Features

The following abbreviations represent SQL Server 2005 editions:

EE = SQL Server 2005 Enterprise Edition
DE = SQL Server 2005 Developer Edition
SE = SQL Server 2005 Standard Edition
WG = SQL Server 2005 Workgroup Edition
SSE = SQL Server 2005 Express Edition
SSEA = SQL Server 2005 Express Edition with Advanced Services

Features/Notification Services Enhancements	EE (32-bit) DE (32-bit) EE (64-bit) DE (64-bit)	SE (32-bit)	WG (32-bit)	SSE (32-bit) SSEA (32-bit)	SE (64-bit)
Notification Services SDK (API, NSControl, ICF/ADF)	Yes	Yes	No	No	Yes
Notification Services Engine and Client components	Yes	Yes	No	No	Yes
Scalability (Parallelism, Multicast, Distributed deployment)	Yes	No	No	No	No

SQL Server 2005 Integration Services Features

The following abbreviations represent SQL Server 2005 editions:

EE = SQL Server 2005 Enterprise Edition
DE = SQL Server 2005 Developer Edition
SE = SQL Server 2005 Standard Edition
WG = SQL Server 2005 Workgroup Edition
SSE = SQL Server 2005 Express Edition
SSEA = SQL Server 2005 Express Edition with Advanced Services

Features/Integration Services Enhancements	EE (32-bit) DE (32-bit) EE (64-bit) DE (64-bit)	SE (32-bit)	WG (32-bit)	SSE (32-bit) SSEA (32-bit)	SE (64-bit)
SQL Server Import and Export Wizard and supporting connections, source and destination adapters, and tasks	Yes	Yes	Yes	No	Yes
Execute SQL Task	Yes	Yes	Yes	No	Yes
OLE DB Source and Destination Adapters	Yes	Yes	Yes	No	Yes
SSIS command prompt tools	Yes	Yes	Yes	No	Yes
SSIS Package Designer	Yes	Yes	Yes	No	Yes
Legacy support for DTS packages	Yes	Yes	Yes	Yes	Yes
SSIS Service	Yes	Yes	No	No	Yes
All other source and destination adapters, tasks, and transformations, except for those listed below	Yes	Yes	No	No	Yes
Data Mining Query Transformation	Yes	No	No	No	No
Data Mining Model Training Destination Adapter	Yes	No	No	No	No
Fuzzy Grouping Transformation	Yes	No	No	No	No
Fuzzy Lookup Transformation	Yes	No	No	No	No
Term Extraction Transformation	Yes	No	No	No	No
Term Lookup Transformation	Yes	No	No	No	No
Slowly Changing Dimension Transformation and Wizard	Yes	Yes	No	No	No
Dimension Processing Destination Adapter	Yes	No	No	No	No
Partition Processing Destination Adapter	Yes	No	No	No	No

SQL Server 2005 Replication Features

The following abbreviations represent SQL Server 2005 editions:

EE = SQL Server 2005 Enterprise Edition
DE = SQL Server 2005 Developer Edition
SE = SQL Server 2005 Standard Edition
WG = SQL Server 2005 Workgroup Edition
SSE = SQL Server 2005 Express Edition
SSEA = SQL Server 2005 Express Edition with Advanced Services

Features/Replication Enhancements	EE (32-bit) DE (32-bit) EE (64-bit) DE (64-bit) 4	SE (32-bit)	WG (32-bit)	SSE (32-bit) SSEA (32-bit)	SE (64-bit)
Merge replication	Yes	Yes	Yes1	Subscriber only2	Yes
Merge replication over HTTPS (Web Synchronization)	Yes	Yes	Yes1	Subscriber only2	Yes
Transactional replication	Yes	Yes	Yes1	Subscriber only3	Yes
Snapshot replication	Yes	Yes	Yes	Subscriber only	Yes
Non-SQL Server Subscribers	Yes	Yes	No	No	Yes
Oracle publishing	Yes	No	No	No	No
Peer-to-peer transactional replication	Yes	No	No	No	No

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

2You cannot configure SQL Server 2005 Express Edition or SQL Server 2005 Express Edition with Advanced Services as a Publisher or Distributor for any type of replication. However, SQL Server 2005 Express Edition or SQL Server 2005 Express Edition with Advanced Services can be a Subscriber, and merge replication allows changes to be replicated in both directions between a Publisher and Subscriber.

3 SQL Server 2005 Express Edition or SQL Server 2005 Express Edition with Advanced Services do not support queued updating using pull subscriptions. It does support queued updating using push subscriptions and immediate updating using push or pull subscriptions (immediate updating requires that Microsoft Distributed Transaction Coordinator (MS DTC) be running on the same computer as the SQL Server 2005 Express Edition or SQL Server 2005 Express Edition with Advanced Services instance).

4Replication supports 32-bit and 64-bit versions of SQL Server in the same topology. All replication features are supported on the 64-bit version with the following considerations:

Push subscriptions from a 64-bit Distributor require the appropriate 64-bit OLEDB provider or ODBC driver at the Distributor; pull subscriptions from a 64-bit Subscriber require the appropriate 64-bit provider or driver at the Subscriber. For more information about push and pull subscriptions, see Subscribing to Publications.
To use Windows Synchronization Manager on a 64-bit Subscriber that is running in Windows on Windows mode (WOW), you must launch the executable mobsync.exe directly from the \Windows\Syswow64 directory, rather than from the Start menu. Launching the executable directly ensures the correct version is used. For more information about WOW, see Hardware and Software Requirements for Installing SQL Server 2005. For more information about Windows Synchronization Manager, see Windows Synchronization Manager.
Transformable push subscriptions from a 64-bit Distributor are not supported, because the necessary 64-bit Data Transformation Services (DTS) components are not available. Pull subscriptions from a 32-bit installation of SQL Server 2005 should work with a 64-bit Publisher or Distributor. For more information about transformable subscriptions, see Transforming Published Data.

Other Resources

Product Specifications for SQL Server 2005

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release	History
15 September 2007	Changed content: Added a link to a SQL Server 2005 Enterprise Edition white paper. Changed support status for "Measure expressions" in Analysis Services. Updated support status for "Service Broker" in SQL Server 2005 Express Editions. Added support for "Encryption." Added support for "Vardecimal Storage Format" in SQL Server 2005 SP2 and later versions. Added support for "Logon Triggers" in SQL Server 2005 SP2 and later versions. Added support for "Common Criteria Compliance" in SQL Server 2005 SP2 and later versions. Added support "Piecemeal restore". Added support for "Merge replication over HTTPS (Web Synchronization)". Added description of limitation on number of mining attributes in Standard Edition. Added support for indexing of the xml data type on SQL Server 2005 Express Edition and SQL Server 2005 Express Edition with Advanced Services.
12 December 2006	Changed content: Removed footnote stating that the Microsoft OLE DB Provider for DB2 is not supported on Itanium architecture. Added support information for "Custom report items" in Reporting Services. Removed reference to "High availability upgrade" feature.
17 July 2006	Changed content: Documented support for Microsoft .NET stored procedures on all editions of SQL Server 2005
5 December 2005	Changed content: Documented support for the Dedicated Administrator Connection feature for SQL Server 2005 Express Edition. Added support information for SQL Server 2005 Express Edition with Advanced Services.