Using SQL 2008 Management Tools with SQL Server 2005 Instance

Question

I currently have SQL Server 2005 installed to a system which is required by multiple programs. I would like to install SQL 2008 Management Studio only so I can manage the SQL 2005 databases.

Is this possible or will SSMS 2008 attempt to upgrade SQL Server 2005. I looked at the installation file for it and its confusing as hell and doesn't give a precise step on making this work

Answer 1

You can install only the client tools for 2008.

This article should help you for that http://www.kendalvandyke.com/2009/01/sql-server-management-studio-2008.html

HTH

---

Regards, Ashwin Menon My Blog - http:\\sqllearnings.com

Answer 2

Thanks, that helps out tremendously. All I need is Basic but those instructions are what I needed.

Thanks Again!