Here are summary of some useful features of MS SQL 2005 Edition:

MS SQL 2005 Express:

• Number of CPUs: - 1
• 1 GB max memory limit for buffer pool
• Database Size: - 4GB
• SQL Server Agent
• Full Text Search
• Advanced Integration Services


MSSQL 2005 Workgroup Edition:

• Number of CPUs: - 2
• Database Size: - No Limit
• SQL Server Agent
• Full Text Search
• IMPORT/EXPORT
• Full Text indexing

MSSQL 2005 Standard Edition:

• Number of CPUs: - 4
• Database Size: - No Limit
• SQL Server Agent
• Full Text Search
• IMPORT/EXPORT
• Basic Integration Services
• Advanced Integration Services
• Database Mirroring
• Full Text indexing


MSSQL 2005 Enterprises Edition:

• CPU: Yes
• Number of CPUs: - No Limit
• Database Size:- No Limit
• SQL Server Agent
• Full Text Search
• IMPORT/EXPORT
• Basic Integration Services
• Advanced Integration Services
• Database Mirroring
• Full Text indexing