开发者

Can I use SQL Server 2008 management studio with SQL Server 2005?

开发者 https://www.devze.com 2023-02-08 21:45 出处：网络

I have management studio 2005 and 2008, can the 2008 version be setup to conn开发者_JAVA技巧ect to 2005? I understand there are new features in 2008 that I wouldn\'t be able to use, but I mainly use t

相关专题：sql-server sql-server-2005 sql-server-2008 ssms

I have management studio 2005 and 2008, can the 2008 version be setup to conn开发者_JAVA技巧ect to 2005? I understand there are new features in 2008 that I wouldn't be able to use, but I mainly use the software to graphical create new tables and assign relationships.

Yes, Sql Server Management Studio 2008 works with Sql Server 2005. ~~However, it does not work with Sql Server 2000.~~

I incorrectly stated that it doesn't work with Sql Server 2000, while in fact it does. However, having said that, it's probably not going to give you a whole lot usability options if you're connecting to Sql Server 2000.