1

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.

Richard Gadsden
  • 3,686
  • 4
  • 29
  • 58
  • Are you sure you are running SQL Server 2010 Management Studio? It seems not exists on Microsoft site. Or do you have this: http://www.sqlmanager.net/en/products/studio/mssql – lg. Jul 28 '10 at 10:00
  • Apologies, I meant 2008 R2, not 2010. Have edited. – Richard Gadsden Jul 28 '10 at 16:08

2 Answers2

0

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

mrdenny
  • 27,174
  • 4
  • 41
  • 69
0

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.

Shane
  • 1,869
  • 4
  • 20
  • 34