Post reply

edition upgrade issue - sql server 2008 r2

  • July 25, 2017 at 5:18 am

    #322788

    re: edition upgrade issue - sql server 2008 r2
    Dear friends,
    I just upgraded all 3 instances of my sql server 2008 r2 including the shared features.
    When I run server sql server’s features discovery report, I get to see the below

    Product Edition Version
    Microsoft SQL Server 2008 R2 Enterprise Edition 10.53.6000.34

    But when I run a select statement from SSMS it shows a different story,

    MajorVersion    ProductLevel     Edition  ProductVersion
    SQL2008 R2        RTM       Standard Edition (64-bit)               10.50.1617.0
    any help to rectify this would be appreciated.

  • July 25, 2017 at 6:00 am

    #1952533

    shamim.ahmed - Tuesday, July 25, 2017 5:18 AM

    re: edition upgrade issue - sql server 2008 r2
    Dear friends,
    I just upgraded all 3 instances of my sql server 2008 r2 including the shared features.
    When I run server sql server’s features discovery report, I get to see the below

    Product Edition Version
    Microsoft SQL Server 2008 R2 Enterprise Edition 10.53.6000.34

    But when I run a select statement from SSMS it shows a different story,

    MajorVersion    ProductLevel     Edition  ProductVersion
    SQL2008 R2        RTM       Standard Edition (64-bit)               10.50.1617.0
    any help to rectify this would be appreciated.

    What is returned when you run select @@version on the upgraded instances through SSMS?

    Thanks

  • July 25, 2017 at 6:09 am

    #1952536

    MajorVersion ProductLevel Edition ProductVersion
    SQL2008 R2 RTM Standard Edition (64-bit) 10.50.1617.0

  • July 25, 2017 at 6:12 am

    #1952537

    shamim.ahmed - Tuesday, July 25, 2017 6:09 AM

    MajorVersion ProductLevel Edition ProductVersion
    SQL2008 R2 RTM Standard Edition (64-bit) 10.50.1617.0

    It should return something like this:
    Microsoft SQL Server 2008 R2 (SP3) - 10.50.6000.34 (X64) Aug 19 2014 12:21:34 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

  • July 25, 2017 at 6:24 am

    #1952539

    that is correct, but it doesn't

  • July 25, 2017 at 6:31 am

    #1952541

    shamim.ahmed - Tuesday, July 25, 2017 6:09 AM

    MajorVersion ProductLevel Edition ProductVersion
    SQL2008 R2 RTM Standard Edition (64-bit) 10.50.1617.0

    That isn't a return result from SELECT @@VERSION;. You would get a 1 column return from that, not 3.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • July 25, 2017 at 6:34 am

    #1952543

    You can always get the SQL Server version from the start of the error log too.

    Thanks

  • July 25, 2017 at 6:37 am

    #1952544

    how does this matter whether its in 3 colum or 1 colum, i run this statement, 

    CASE
      WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '8%' THEN 'SQL2000'
      WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '9%' THEN 'SQL2005'
      WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '10.0%' THEN 'SQL2008'
      WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '10.5%' THEN 'SQL2008 R2'
      WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '11%' THEN 'SQL2012'
      WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '12%' THEN 'SQL2014'
      WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '13%' THEN 'SQL2016' 
      ELSE 'unknown'
    END AS MajorVersion,
    SERVERPROPERTY('ProductLevel') AS ProductLevel,
    SERVERPROPERTY('Edition') AS Edition,
    SERVERPROPERTY('ProductVersion') AS ProductVersion

  • July 25, 2017 at 6:44 am

    #1952547

    shamim.ahmed - Tuesday, July 25, 2017 6:37 AM

    how does this matter whether its in 3 colum or 1 colum, i run this statement, 

    CASE
      WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '8%' THEN 'SQL2000'
      WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '9%' THEN 'SQL2005'
      WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '10.0%' THEN 'SQL2008'
      WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '10.5%' THEN 'SQL2008 R2'
      WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '11%' THEN 'SQL2012'
      WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '12%' THEN 'SQL2014'
      WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '13%' THEN 'SQL2016' 
      ELSE 'unknown'
    END AS MajorVersion,
    SERVERPROPERTY('ProductLevel') AS ProductLevel,
    SERVERPROPERTY('Edition') AS Edition,
    SERVERPROPERTY('ProductVersion') AS ProductVersion

    Why pretend that you were running SELECT @@VERSION?
    What is returned when you do run it or alternative look at the beginning of the error log?

    Thanks

  • July 25, 2017 at 6:52 am

    #1952550

    just running SELECT @@VERSION does not give you an accurate detailed information, this is a bad practice and laziness.

    i just installed ssms v17 and its showing me what i want to see. not i need to uninstall old management tools.

    i guess its to do with version of SSMS

    thanks for your help

Viewing 10 posts - 1 through 10 (of 10 total)

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy