SQL Server Management Studio (SSMS) is backward compatible, and it is always recommended to use the latest version even if you are connecting to older versions of SQL Server such as SQL Server 2008.
Explanation
At the time of writing this tutorial, SSMS 18.4 was the latest release in November 2019, and we will be using this version in this tutorial. Version 18.4 will work with SQL Server 2008 through SQL Server 2019.
Also, it is fine to have slightly older versions, such as 17.X, since these later versions support a lot of the newer features and also support Azure SQL database. If possible, it is always best to use the latest version.
To find the version in SSMS, select menu items Help > About and the following will open.
MSSQLTips.com delivers SQL Server resources to solve real world problems for DBAs, Architects, DevOps Engineers, Developers, Analysts, Cloud and Business Intelligence Pros – all for free. The content we serve is all human written and based on our authors’ real-world experience. Check out tips, articles, scripts, videos, tutorials, live events and more all related to SQL Server on-premises and in the cloud.
