Can I use Management Studio for SQL Server 2000 ?

We are using SQL Server 2000 and are going to install the first SQL Server
2005. We would like to know whether it is possible to use Management Studio
to manage all existing SQL 2000 Servers ?
ThanksYes, I use Management Studio against my SQL 2000 servers here.
There are some things in EM that are no longer or work differently in
Management Studio, but on balance you will hopefully find an improvement.
Tony.
Tony Rogerson
SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson - technical commentary from a SQL
Server Consultant
http://sqlserverfaq.com - free video tutorials
"John" <John@.discussions.microsoft.com> wrote in message
news:euhNCHexGHA.1888@.TK2MSFTNGP03.phx.gbl...
> We are using SQL Server 2000 and are going to install the first SQL Server
> 2005. We would like to know whether it is possible to use Management
> Studio to manage all existing SQL 2000 Servers ?
> Thanks
>|||Yes, you can use SSMS to manage SQL 2000 servers. For DTS designer support,
you'll need to install the SQL Server 2000 DTS Designer Components, which
can be downloaded from:
http://www.microsoft.com/downloads/...&displaylang=en
Hope this helps.
Dan Guzman
SQL Server MVP
"John" <John@.discussions.microsoft.com> wrote in message
news:euhNCHexGHA.1888@.TK2MSFTNGP03.phx.gbl...
> We are using SQL Server 2000 and are going to install the first SQL Server
> 2005. We would like to know whether it is possible to use Management
> Studio to manage all existing SQL 2000 Servers ?
> Thanks
>|||Dear Dan and Tony,
Thank you for your advice.
John
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:%23QM2zQexGHA.428@.TK2MSFTNGP03.phx.gbl...
> Yes, you can use SSMS to manage SQL 2000 servers. For DTS designer
> support, you'll need to install the SQL Server 2000 DTS Designer
> Components, which can be downloaded from:
> http://www.microsoft.com/downloads/...&displaylang=en
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "John" <John@.discussions.microsoft.com> wrote in message
> news:euhNCHexGHA.1888@.TK2MSFTNGP03.phx.gbl...
>