|
1 |
originally posted 2015-01-06 |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 |
select [Product] = convert(nvarchar(25), case when [Version] like '12.%' then 'SQL Server 2014' when [Version] like '11.%' then 'SQL Server 2012' when [Version] like '10.50%' then 'SQL Server 2008 R2' when [Version] like '10.%' then 'SQL Server 2008' when [Version] like '9.%' then 'SQL Server 2005' when [Version] like '8.%' then 'SQL Server 2000' else 'Unknown' end) ,[Version] ,[VersionMajor] = convert(int, left([Version], charindex('.', [Version], 0)-1)) ,[VersionInfo] = @@version ,[Level] ,[Edition] ,[BackupCompression] = convert(bit, case when [Version] like '12.%' and ([Edition] like '%enterprise%' or [Edition] like '%intelligence%' or [Edition] like '%standard%') then 1 --2014 when [Version] like '11.%' and ([Edition] like '%enterprise%' or [Edition] like '%intelligence%' or [Edition] like '%standard%') then 1 --2012 when [Version] like '10.%' and [Edition] like '%enterprise%' then 1 --2008 else 0 end) from ( select [Version] = convert(sysname,serverproperty('ProductVersion')) ,[Level] = convert(sysname,serverproperty ('productlevel')) ,[Edition] = convert(sysname,serverproperty ('edition')) ) as v |
