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