SQL Management Studio Install
Hi Experts,
I'm new to sql and I need to install the management studio so I have some questions.
Should you match the management studio version with the sql server version installed. for example, if sql express 2008r2 is installed does that mean I have to install management studio express 2008r2 as well?
Thx.
I'm new to sql and I need to install the management studio so I have some questions.
Should you match the management studio version with the sql server version installed. for example, if sql express 2008r2 is installed does that mean I have to install management studio express 2008r2 as well?
Thx.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Éric Moreau
You don't. I am currently running SSMS 2016 on my laptop and connecting to various versions of SQL Servers including 2008 R2 Express.
It is possible to use SSMS 2012 to manage SQL Server of version 2005, 2008, 2008R2, the tool is backward compatible.
SSMS Express is a light tool, with it you can't manage features which are available in Standard/Enterprise Edition.
SSMS Express is a light tool, with it you can't manage features which are available in Standard/Enterprise Edition.
ASKER
Oh so it's ssms intended for remote management...install on one server to manage many in the same network or are you supposed to install locally on each SQL server?
It's up to how you manage your servers, we install on the SQL Server, and on our Management Workstations and Laptops.
SSMS is not backward compatible. Some features just don't work with older releases. Editing tables and similar tasks work, though.
>>Some features just don't work with older releases
those limitations are not related to SSMS, they are related to the T-SQL which is executed by the server and not by SSMS. For example, if you are trying to run a query using LAG (which started on SQL 2012) on a 2008 instance, it won't run whatever the version of SSMS you have.
SSMS is just an interface to send request to a server and display results.
those limitations are not related to SSMS, they are related to the T-SQL which is executed by the server and not by SSMS. For example, if you are trying to run a query using LAG (which started on SQL 2012) on a 2008 instance, it won't run whatever the version of SSMS you have.
SSMS is just an interface to send request to a server and display results.
Cross-checked, and different from earlier releases SSMS 2016 is indeed compatible back to 2008. I had issues with different SSMS releases against different DB releases in the past, where backward compatibility was an issue (e.g. in Activity Monitor, script generation and so on).
Additional note: Starting with SSMS 2016 (cannot tell for 2014) there is no Express Edition anymore. SSMS is full-featured and free, and a separate download.
Additional note: Starting with SSMS 2016 (cannot tell for 2014) there is no Express Edition anymore. SSMS is full-featured and free, and a separate download.
Do you have any additional question or we can close it?
ASKER
answers are here. sorry I took so long to close.