Doing without SQL 2000 Enterprise Manager

Written on September 15, 2006

I’ve been using the new Microsoft SQL Server Management Studio, the new administrative tool that comes with SQL 2005.

I’ve also kept a copy of SQL 2000 Enterprise Manager installed, because that was the only way I could edit and maintain the DTS packages we have running on our SQL 2000 boxes.

However, today I discovered that if you install the Microsoft SQL Server 2000 DTS Designer Components, which is part of the Feature Pack for Microsoft SQL Server 2005 - April 2006, then not only can you open and edit DTS packages on a 2005 server, but you can also do the same on a 2000 server.

So as far as I can tell, I don’t need to run the SQL 2000 client tools anymore.

Categories: SQL