I was trying to install SqlServer 2008 and got an error saying, that my Visual Studio (namely Visual C# 2008 Express) was not up-to-date, and it required VS 2008 SP1. The only update I have found on MS download site says that it doesn't work with Express Editions. How to update the Express Edition to SP1?
Besides, does Management Studio Express support working with Sql Compact (3.5) databases (sdf files)? That's actually what I need all this for.
How to update the Express Edition to SP1?
You would just install the Express Edition with Service Pack 1 overtop of your existing Express product. You can download them here.
It's recommended to update to the latest version of Visual Studio Express as 2008 Express is no longer available.
Besides, does Management Studio Express support working with Sql Compact databases (sdf files)?
Yes. From MSDN:
Microsoft SQL Server Management Studio Express (SSMSE) provides a graphical management tool for SQL Server 2008 Express (SQL Server Express), SQL Server 2008 Express with Advanced Services, and (SQL Server Compact 3.5 SP1).
