Hello, You may management to have only one ssms installed on studio your management computer.
Database with, management Tools.Id44272, and some articles about this last SP: px, px and Pay attention management to the, read server server Committed Snapshot Isolation bug.Another point : you may have sometimes problems with a ssms(E) with a Service Pack Service Pack of your databases/instances.And a lot of links to download your version of ssms 2008R2 studio of choice (remember: this version does not include Job Activity Monitor neither bids (ssis Designer Profiler and advanced stuff). Id44271, sQL Server 2008 R2 SP3 Feature Pack: px?
SQL Express home page : You can manually download and install any edition of SQL Server 2008 directly from the Microsoft Download plus Center: Which edition of SQL Server 2008 Express is right for you?
Once you get to the "Installation Type" step of the installation, instead of adding a life new management feature to the existing SQL Instance (that I initially setup as sqlexpress try the install new instance, or something to that effect.
Get the smaller files, that start with sqlmanagementStudio_ (gosh, this shouldnt be battery this hard to find ssms 2008 R2 with SP1: px?
SQL Server 2008 Express with Tools.
So here it is, an sansa update as a post.
But if you uses old version anime then some new features might not work of fit.
Update as of : It looks like the product site from SQL2012 will not list the ssms for 2008 anymore (I tried searching for it in several ways so I google around a bit to find the correct links to get the most recent version.You won't need that anymore because you've installed that earlier.Update: life update: update: update: update: update: update: update: update: A commenter by the name of "matt" has an update: I founolution TO THE problem above.Step 3 Download and install Windows PowerShell.0.There will be no Express version this time, so you have to install ssms SP2 and then run the full SP3 installation in order to get your tools up-to-date.Uncheck the first two checkboxes that have something to do with a new SQL Instance.Have a nice day, mark Post as helpful if it provides any help.SQL Server Database Engine, sQL Server Management Studio Express, full-Text Search.
Install on and be done!
One last thing: Step 1: Download and install, microsoft.Net Framework.5, sP1.
Note: There are multiple files available for this download.