SQL Server Feature Comparison (2005 – 2008)

This is something we’ve had under our hat where I work for a while.. as you should be aware if you do a "stand-alone" install of WSS 3.0 (or MOSS 2007) then it installs "SQL Express Edition" (a.k.a. MSDE) .. but this version does have some startling limitations!
 

SQL 2005 Feature Comparison

 

Express

Workgroup

Standard

Enterprise

Number of CPUs

1

2

4

No Limit

Max. RAM

1 GB

3GB

OS Limit

OS Limit

64-bit support?

 

 

X

X

Max. Database Size

4GB

No Limit

No Limit

No Limit

Clustering / Mirroring

 

 

X

X

Online Restore / Recovery

 

 

 

X

Management Studio

 

X

X

X

Job Scheduling (through Agent)

 

X

X

X

Import / Export

 

X

X

X

Web Services

 

 

X

X

 

Much more also available at Microsoft SQL Server 2005 Features Comparison.

 

SQL 2008 Feature Comparison

 

Compact

Express

Standard

Enterprise

Number of CPUs

1

1 (per server)

4

No Limit

Max. RAM

OS Limit

1GB

OS Limit

OS Limit

64-bit support?

 

 

X

X

Max. Database Size

4GB

4GB

No Limit

No Limit

Clustering / Mirroring

 

 

X

X

Online Restore / Recovery

 

 

 

X

Management Studio

 

(tool)

X

X

Job Scheduling (through Agent)

 

 

X

X

Import / Export

(tool)

 

X

X

Web Services

 

 

X

X

 

Detailed comparisons can be found between Compact and Express … and Standard and Enterprise