Friday, 15 September 2006

Doing without SQL 2000 Enterprise Manager

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.

No comments: