none
How to determine if CU2 for SQL 2005 SP3 has been applied ?

    Question

  • We applied SP3 for SQL Server 2005 and we see that when we run the "SELECT @@VERSION" SQL. However, when we applied the CU2 on top of SP3, we see the same results with the above select. How do we know if Cu2 was successfully applied?

    Thanks
    Jagannathan
    Jagannathan
    Tuesday, March 31, 2009 1:22 PM

Answers

  • Are you sure that you checked all of the components on the instance when you ran CU2 for SP3 ?  You might try running CU2 again.

    Here is what I see after CU1 for SQL Server 2005 SP3 has been installed:

    Microsoft SQL Server 2005 - 9.00.4207.00 (Intel X86)   Dec 17 2008 14:34:38   Copyright (c) 1988-2005 Microsoft Corporation  Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 2)


    Here is what I see after CU2 for SQL Server 2005 SP3 has been installed:

    Microsoft SQL Server 2005 - 9.00.4211.00 (Intel X86)   Jan 30 2009 13:43:44   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

    This KB article lists all of the post SP3 builds for SQL Server 2005
    http://support.microsoft.com/kb/960598/
    http://glennberrysqlperformance.spaces.live.com/ Please mark as the answer if this post solved your issue.
    Tuesday, March 31, 2009 10:28 PM

All replies

  • You should see Build 4211 after applying CU2 for SQL Server 2005 SP3 when you run SELECT @@VERSION.
    http://glennberrysqlperformance.spaces.live.com/ Please mark as the answer if this post solved your issue.
    Tuesday, March 31, 2009 6:00 PM
  • All I see is

    Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)   Nov 24 2008 13:01:59   Copyright (c) 1988-2005 Microsoft Corporation  Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

    This is after successfully applying SQL 2005 SP3 and CU2 with no error messages. What are we missing?
    Jagannathan
    Tuesday, March 31, 2009 9:42 PM
  • Are you sure that you checked all of the components on the instance when you ran CU2 for SP3 ?  You might try running CU2 again.

    Here is what I see after CU1 for SQL Server 2005 SP3 has been installed:

    Microsoft SQL Server 2005 - 9.00.4207.00 (Intel X86)   Dec 17 2008 14:34:38   Copyright (c) 1988-2005 Microsoft Corporation  Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 2)


    Here is what I see after CU2 for SQL Server 2005 SP3 has been installed:

    Microsoft SQL Server 2005 - 9.00.4211.00 (Intel X86)   Jan 30 2009 13:43:44   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

    This KB article lists all of the post SP3 builds for SQL Server 2005
    http://support.microsoft.com/kb/960598/
    http://glennberrysqlperformance.spaces.live.com/ Please mark as the answer if this post solved your issue.
    Tuesday, March 31, 2009 10:28 PM
  • I see one issue, I did not apply CU1 on top of SP3. Does CU2 include CU1 too? BTW, I see 2 CU1 downloads,

    SQL Server 2005 English x86 sp3 Yukon_SP3_CU1_SNAC 2005 09.00.4207 3198620 12/19/2008 8:36:51 PM
    SQL Server 2005 English x86 sp3 Yukon_SP3_CU1


    Which one do I use? And what does SNAC stand for?  SQL Native Client?

    I tried installing CU1_SNAC and it threw a message that I was at a higher version already. I finished reinstalling CU2 and it does not pose me with a wide set of options, just "Client Components" and "SQL Server Native Client SDK". No sub-options.
    Jagannathan
    • Edited by jsanthanam Wednesday, April 01, 2009 1:50 PM
    Wednesday, April 01, 2009 1:22 PM
  • Yes, CU2 includes all the stuff from CU1.  You do not need to install CU1 before CU2.
    Wednesday, April 01, 2009 1:47 PM
  • Well, I have installed CU2 again several times and I do not see the correct version for CU2 when I run @@version. I even rebooted the server after applying CU2.
    Jagannathan
    Wednesday, April 01, 2009 1:55 PM
  • Maybe you are accidentally running CU2 on your workstation instead of the actual database server?  You should see something that talks about database engine services in the components list when you run the CU2 setup program.

    CU2 does include CU1, so no need to run CU1 first.
    http://glennberrysqlperformance.spaces.live.com/ Please mark as the answer if this post solved your issue.
    Wednesday, April 01, 2009 5:02 PM
  • Well, I have spent 15+ years in SQL Server technology and I am forgetful sometimes but not that forgetful :) I am logged onto the server.
    Jagannathan
    Wednesday, April 01, 2009 5:15 PM