enterprise manager for SQL 2000

Hello,
I have been using SQL 7 for some time and so have the
Enterprise manager to match. I have just started work on a
remote SQL server, which runs SQL 2000 - and so my
Enterprise manager can't communicate with it.
I have looked everywhere, but can't see a way of
controlling the remote server without upgrading my SQL
server to version 2000. This seems a bit of an overkill
when all I want to do is create and import a few tables on
the remote server.
Do I really have to pay for a whole system upgrade, even
though I don't want to use SQL 2000 here, just so I can
import some tables? I can't seem to locate an alternative
Microsoft solution.
Thanks.
DCIf you upgrade your CLient Utilites to SQL2k you will be able to communicate
with the SQL7 and SQL2K boxes. It's backward compatible.
--
HTH
Ryan Waight, MCDBA, MCSE
"david cox" <davidcox@.mail.com> wrote in message
news:044401c37d08$f422d640$a001280a@.phx.gbl...
> Hello,
> I have been using SQL 7 for some time and so have the
> Enterprise manager to match. I have just started work on a
> remote SQL server, which runs SQL 2000 - and so my
> Enterprise manager can't communicate with it.
> I have looked everywhere, but can't see a way of
> controlling the remote server without upgrading my SQL
> server to version 2000. This seems a bit of an overkill
> when all I want to do is create and import a few tables on
> the remote server.
> Do I really have to pay for a whole system upgrade, even
> though I don't want to use SQL 2000 here, just so I can
> import some tables? I can't seem to locate an alternative
> Microsoft solution.
> Thanks.
> DC