Limitations of SQL Server 2008 R2 Express

1. Maximum 10 GB per database.

2. Uses no more than 1 processor.

3. Uses no more than 1 GB of internal memory.

4. NO Maintenance plans

5. NO Database mail

6. NO User instances

7. SQL Server Agent

8. NO Full-text search