June 17, 2015 at 4:30 am
I ran the following:
SELECT
SERVERPROPERTY('productversion') as 'Product Version',
SERVERPROPERTY('productlevel') as 'Product Level',
SERVERPROPERTY('edition') as 'Product Edition',
SERVERPROPERTY('buildclrversion') as 'CLR Version',
SERVERPROPERTY('collation') as 'Default Collation',
SERVERPROPERTY('instancename') as 'Instance',
SERVERPROPERTY('lcid') as 'LCID',
SERVERPROPERTY('servername') as 'Server Name'
I get the following:
Product VersionProduct LevelProduct EditionCLR VersionDefault CollationInstanceLCIDServer Name
12.0.2000.8RTMStandard Edition (64-bit)v4.0.30319Latin1_General_CI_ASNULL1033ALPHA001
Am I using the RTM or Standard Version of Sql 2014? I see both...
J.
June 17, 2015 at 4:37 am
RTM is the product level, Standard is the edition. They're two different things.
Product level means which updates (service packs and CUs) are installed.
Edition means which features are included in the SKU.
-- Gianluca Sartori
June 17, 2015 at 4:38 am
Thanks. I take it there fore I can update to SP1...??
June 17, 2015 at 4:54 am
Of course you can
-- Gianluca Sartori
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply