


Just use the Add Feature "feature" of setup to add Management Tools - Complete (you can also remove the Complete feature if you decide later you don't want it).Īs described in the advertisements for SQL Server 2008 Express on the download page?Įffectively it is the same features of Management Studio as though you had picked Management Tools - Basic on a standard installation of SQL Server 2008.

If you pick this option, but later "want it all", no problem. So if you only want to install Management Studio to monitor and manage the Database Engine and want to reduce the amount of software installed on your machine, then just pick Management Tools - Basic. Plus you get other tools installed such as Database Tuning Advisor (DTA) and SQL Profiler. You can use SQL Server Management Studio with Object Explorer for Analysis Services, Integration Services, and Reporting Services. Management Tools - Complete is as the name implies. , the description shows what additional features and tools are included in this feature selection. The Description window describes what is included with this feature, which is basically (no pun intended) SQL Server Management Studio (plus SQLCMD and Powershell support). In this case I had selected the Feature called Notice the Description window on the right I've circled. When you install SQL Server 2008 editions other than SQL Server 2008 Express, you are presented with a Feature Selection screen like the following: Related to this are questions I've received on what isĪs described in the download pages for SQL Server 2008 Express. So I thought I'd blog about these to resolve any questions you might have. A few questions have come up about the differences between the features you can install on SQL Server 2008 called
