I'm reinstalling apps on my system and wanted to know which SQL Server version I should install. I'm debating between 2005 and 2008, but I have lots of sql server 2000 databases to manage. My main question is can you manage sql server 2000 databases with sql server 2008 client tools or should I just install 2005?

Shawn M. Ferguson
Supervisor of Information Services
sfergus2 (AT) cscc (DOT) edu
1(800)621-6407
(614) 287-2502 Voice
(614) 287-5488 FAX

Shawn,

SQL Server 2008 Management Studio can manage SQL Server 2000. If you need
to manage DTS packages, you will need to download some of the backward
compatibility components for 2000.

There is a thread about it here:
http://www.sqlmonster.com/Uwe/Forum....ner-Components


RLF

"Shawn Ferguson" <SFergus2 (AT) cscc (DOT) edu> wrote


--------------------------------------------------------------------------------