none
@@version

    Question

  • I checked add remove programs on my server and it says I have SP3 for Sql Server 2005.  When I do a select @@version I am seeing SP2.  Does anyone else have this problem, or do you know if I'm missing something?

    Thank you for your time.
    Wednesday, February 17, 2010 3:33 PM

Answers

  • No, here is what it returns for me Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)   Mar 29 2009 10:11:52   Copyright (c) 1988-2008 Microsoft Corporation  Express Edition with Advanced Services (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2)

    So, it does return the SQL Server at the very begining. I'm just suspecting that James looked at the end of the return value, not the begining.
    Premature optimization is the root of all evil in programming. (c) by Donald Knuth

    Naomi Nosonovsky, Sr. Programmer-Analyst

    My blog
    • Marked as answer by James12314909 Wednesday, February 17, 2010 4:24 PM
    Wednesday, February 17, 2010 3:56 PM
  • See http://support.microsoft.com/default.aspx?scid=kb;EN-US;321185


    Premature optimization is the root of all evil in programming. (c) by Donald Knuth

    Naomi Nosonovsky, Sr. Programmer-Analyst

    My blog
    • Marked as answer by James12314909 Wednesday, February 17, 2010 5:16 PM
    Wednesday, February 17, 2010 4:46 PM

All replies

  • May be it was downloaded but never installed. I have the same issue on one of my 2005 servers
    Abdallah El-Chal, PMP, ITIL, MCTS
    Wednesday, February 17, 2010 3:36 PM
  • When I do a select serverproperty('ProductLevel') it gives me SP3.  I wonder if a reinstall will fix @@version
    Wednesday, February 17, 2010 3:43 PM
  • Where do you see SP2? Can you post the exact value @@VERSION returns?
    Premature optimization is the root of all evil in programming. (c) by Donald Knuth

    Naomi Nosonovsky, Sr. Programmer-Analyst

    My blog
    Wednesday, February 17, 2010 3:49 PM
  • EEEEEEEEEkkk, ,wait.
    @@version returns the OS version and not SQL Server.


    Abdallah El-Chal, PMP, ITIL, MCTS
    Wednesday, February 17, 2010 3:51 PM
  • No, here is what it returns for me Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)   Mar 29 2009 10:11:52   Copyright (c) 1988-2008 Microsoft Corporation  Express Edition with Advanced Services (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2)

    So, it does return the SQL Server at the very begining. I'm just suspecting that James looked at the end of the return value, not the begining.
    Premature optimization is the root of all evil in programming. (c) by Donald Knuth

    Naomi Nosonovsky, Sr. Programmer-Analyst

    My blog
    • Marked as answer by James12314909 Wednesday, February 17, 2010 4:24 PM
    Wednesday, February 17, 2010 3:56 PM
  • This part here
    Build 6002: Service Pack 2

    is the OS SP version
    Abdallah El-Chal, PMP, ITIL, MCTS
    Wednesday, February 17, 2010 3:57 PM
  • Right - exactly my point.
    Premature optimization is the root of all evil in programming. (c) by Donald Knuth

    Naomi Nosonovsky, Sr. Programmer-Analyst

    My blog
    Wednesday, February 17, 2010 4:01 PM
  • I'm feeling rather sheepish.   I did look at the end and made the mistake to think that was describing MS SQL Server.  However, I am using  sql 2005 and the sp version is not showing up the way yours does in 2008.  I think 2008 must correct this, but 2005 is missing it - unless I am again reading it incorrectly.

    It looks like I have to look at the version displayed after the sql server for 2005.  For example, 9.00.4053.00.  I then need to know that is SP3.  2008's display of @@version is much nicer.

    Thanks
    • Edited by James12314909 Wednesday, February 17, 2010 4:25 PM clarity
    Wednesday, February 17, 2010 4:23 PM
  • You are not reading it incorrectly.
    It doesn't show in 2005 version.
    Abdallah El-Chal, PMP, ITIL, MCTS
    Wednesday, February 17, 2010 4:25 PM
  • SP3 download shows the version 9.00.4053.00 which matches @@version for me
    http://www.microsoft.com/downloads/details.aspx?familyid=0d878f4b-71e8-4170-9a14-1bce684811ce&displaylang=en

    I don't have a sp2 box to check to see if it matches the below version number.

    SP2 download shows 9.00.3042
    http://www.microsoft.com/downloads/details.aspx?FamilyId=D07219B2-1E23-49C8-8F0C-63FA18F26D3A&displaylang=en

    Wednesday, February 17, 2010 4:31 PM
  • See http://support.microsoft.com/default.aspx?scid=kb;EN-US;321185


    Premature optimization is the root of all evil in programming. (c) by Donald Knuth

    Naomi Nosonovsky, Sr. Programmer-Analyst

    My blog
    • Marked as answer by James12314909 Wednesday, February 17, 2010 5:16 PM
    Wednesday, February 17, 2010 4:46 PM