Post reply

SQL Server 2005: Upgrade Error SP2 to SP3

  • December 3, 2009 at 10:02 am

    #1087240

    Hi,

    What does return this?

    select @@version

  • December 3, 2009 at 10:36 am

    #1087258

    It displays the SQL Server information along with Windows Server Information and people get confused when they see the "Service Pack 2" at the end of that message.

    Use this command

    select serverproperty('ProductLevel')

    Which will give your SQL Server SP Level.

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • December 3, 2009 at 10:52 am

    #1087265

    select @@version produces:

    Microsoft SQL Server 2005 - 9.00.4053.00 (X64) May 26 2009 14:13:01 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

    select serverproperty('ProductLevel') produces:

    SP3

    So, it appears that I don't have to run the SP3 again. Like I said above, I manually ran the *.MSI packages that failed during the SP3.

    Thanks!

  • December 3, 2009 at 11:01 am

    #1087267

    You are welcome ! 🙂

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • December 3, 2009 at 11:14 am

    #1087271

    One final question: Why the descrepency?

    select @@version says SP2

    select serverproperty('ProductLevel') says SP3

    Which one to believe?

    Thanks.

  • December 3, 2009 at 11:18 am

    #1087273

    Believe both. The SP info in the result of @@Version is actually for Windows Server so it is Windows Server SP2.

    Where as serverproperty('ProductLevel') is for SQL Server.

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

Viewing 6 posts - 16 through 20 (of 20 total)

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