Home / server / Questions / 164744
Accepted
Richard Gadsden
Asked: 2010-07-29 01:50:07 +0800 CST

Is SQL Server Management Studio capable of managing SQL Server 2000 databases?

  • 772

I know this is really basic, but I can't find the answer in Google or SF, so I thought I'd better just ask.

If I run SQL Server 2008 R2 Management Studio on my PC, can I manage a SQL Server 2000 database server?

I know I can do it from SQL Server 2008 (non-R2) Management Studio, though I need a legacy component to manage Data Transformation Services. I can cope fine without that component - all my DTS has been migrated to SSIS on a SQL 2005 / 2008 Servers, but I still have a legacy 2000 server and I'd like to be able to admin everything from one console.

sql-server sql-server-2008-r2

2 Answers

  1. I'm pretty sure that it can connect to a SQL 2000 server.

    • 0
  2. Best Answer

    Yes it can connect to a SQL Server 2000 instance. You do lose some functionality like the activity monitor so depending on your daily needs in terms of database monitoring you may need to have multiple version of the management studio installed.

    • 0