Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Location
    Poland
    Posts
    35

    Unanswered: Sql 2005 9.0.3042 & 9.0.3054

    Dear All

    I've installed two SQL 2005 servers on two Windows 2003 machines.
    I've used the same installation source for booth installation.
    Booth of SQL servers working fine butI have two different versions on each machine.
    1. SQL Server 9.0.3042
    2. SQL Server 9.0.3054

    How can I correct it?
    ThanksIn advance.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Connect to each using SQL WorkBench, and run the following:
    Code:
    select @@version
    Post the results, even if it is an error.

  3. #3
    Join Date
    Jan 2004
    Location
    Poland
    Posts
    35

    Sql 2005 9.0.3042 & 9.0.3054

    Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)



    Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    You appear to have two different versions of Service Pack 2. Delete both, re-download the latest version, and use that.

  5. #5
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by MCrowley
    You appear to have two different versions of Service Pack 2. Delete both, re-download the latest version, and use that.

    The initial (pre March 7) release of SP2 had an issue related to Maintenance Plans and how frequently the maintenance plan would be scheduled to run (ask me how I know). The post March 7 release of SP2 fixed the "issue". I believe that is what is being dealt with here, though I no longer have the older version installed anywhere in my environment and I don't off the top of my head remember what the version number was.

    Regards,

    hmscott
    Have you hugged your backup today?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •