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 9 (of 9 total)

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