Post reply

Upgrading to SQL 2005 ENT from SQL 2000

  • October 6, 2009 at 7:55 pm

    #385518

    Hello,

    I just run a test upgrade on SQL 2000 ENT (SP4) to SQL 2005 ENT. I took the default instance (in place upgrade?).

    The installation completes successfully. I noticed there still exists the

    SQL Enterprise manager from the SQL 2000 version. The databases are visible on the Enterprise Manager 2000 and the new SQL Server Management Studio.

    I did a test by bringing a database offline/online and it seems the action

    taken on the Enterprise manager (2000) or Studio Manager (2005) will reflect the change by the other.

    Is this how it supposed to be? I did download the technical reference but thought I run through this site first.

    TIA,

    tnt

  • October 6, 2009 at 8:00 pm

    #1062565

    rebooting the server may resolve the issue (may remove enterprise manager)

  • October 7, 2009 at 12:05 am

    #1062593

    Rebooting doesn't remove it 🙁

    I noticed two things:

    1) I tried creating a new database from either console, it will also reflect the change on the other console.

    2) The sql server management studio version is 8.00.2039 with SELECT @@Version command. It has the same version from the Enterprise Manager. Now I am confused.

    tnt

  • October 7, 2009 at 3:25 pm

    #1063112

    Remove it manually.

    MJ

Viewing 4 posts - 1 through 3 (of 3 total)

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