July 25, 2017 at 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.
July 25, 2017 at 6:00 am
shamim.ahmed - Tuesday, July 25, 2017 5:18 AMre: 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
MajorVersion ProductLevel Edition ProductVersion
SQL2008 R2 RTM Standard Edition (64-bit) 10.50.1617.0
July 25, 2017 at 6:12 am
shamim.ahmed - Tuesday, July 25, 2017 6:09 AMMajorVersion 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
that is correct, but it doesn't
July 25, 2017 at 6:31 am
shamim.ahmed - Tuesday, July 25, 2017 6:09 AMMajorVersion 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
You can always get the SQL Server version from the start of the error log too.
Thanks
July 25, 2017 at 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
July 25, 2017 at 6:44 am
shamim.ahmed - Tuesday, July 25, 2017 6:37 AMhow 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
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