Microsoft has offered the download of SQL Server 2008 with advanced services for FREE, but only suitable for learning and building desktop and small server applications, and for redistribution by ISVs.
If you are still confused if its full featured download, here is what Microsoft SQL Server 2008 Express with Advanced Services means:
* SQL Server database engine – create, store, update and retrieve your data
* SQL Server Management Studio Basic – visual database management tool for creating, editing and managing databases
* Full-text Search – powerful, high-speed engine for searching text-intensive data
* Reporting Services – integrated report creation and design environment to create reports
Note: Please go through all the details mentioned in Microsoft details before downloading