In order to add features from the full version of SQL Server 2008 R2 to the Express version.
Get a hold of the full version DVD or installation media, then use the following command from the command prompt;
setup.exe /FEATURES=Tools /Q /INDICATEPROGRESS /ACTION=Install /INSTANCENAME=UPSTAIRSSQLEXPRESS /BROWSERSVCSTARTUPTYPE=Automatic /AGTSVCACCOUNT=”NT AUTHORITYNETWORK SERVICE” /IACCEPTSQLSERVERLICENSETERMS
Aha! That’s how you do it!
Does that apply to the workgroup edition as well as the standard edition?
Thanks for the comment Steve…. I believe this applies to any edition of SQL Server 2008 R2.