:::: MENU ::::

Can SQL Server management studio (SSMS) be used with other versions of SQL Server

  • Jun 11 / 2009
  • 0
DBA Interview questions, dbDigger, SSMS tips and tricks

Can SQL Server management studio (SSMS) be used with other versions of SQL Server

Can SQL Server management studio (SSMS) be used with other versions of SQL Server. Although a very basic but important questions for new users of SQL Server. It always amazed me that you can connect any version of SQL Server management studio (SSMS) to any of previous version instance of SQL Server. I used SSMS 2005 for a long time to work with instance of SQL Server 2000. And currently i am using SSMS 2008 to work with instances of SQL Server 2000/2005 and 2008.
But you can not use SSMS 2005 to connect and work with SQL Server 2008 instance. Hence main rule is that SSMS can connect to instances of its current version and previous versions. It can not connect to SQL Server instances that are later than version of SSMS.

Consult us to explore the Databases. Contact us