Remote sql 2000 admin from vista

  • Hi

    Ive just got a new laptop which has vista on it, Within XP I used enterprise manager to alter remote sql 2000 tables/data etc, what can I do with vista.

    If I get the 2005 Developer edition does that contain something that can work with remote sql 2000.

    What about the 2008 Developer edition?

    Any help would be great

    Cheers

  • You can install the client tools on your laptop. But I am not sure about 2008.

  • Hi

    So will the client tools for sql 2005 work with sql 2000?

    David

  • With Windows XP SP2 or later, the answer is Yes.

  • Yes, you can use the 2005 client tools to manage SQL Server 2000. You can even manage a 2000 instance with the 2008 tools, however - there are a few things that won't work.

    For example, in 2008 they changed the activity monitor and it will no longer work against a 2000 instance but works fine against a 2005 instance.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • Cheers thats really helpful

    Thank you

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply