Untitled

How to determine SQL Server 2008 or above

SELECT

   PARSENAME(CAST(SERVERPROPERTY('ProductVersion') AS varchar(20)), 3) AS MajorVersion,

   value_in_use

FROM

   sys.configurations

WHERE

   name = 'clr enabled';

       

select @@VERSION

 

SELECT * FROM sys.configurations WHERE name = 'clr enabled'

 

SELECT compatibility_level from sys.databases where name=db_name()

       

select

    CASE

        WHEN LEFT(@@VERSION,25)='Microsoft SQL Server 2008' THEN 'Yes'

        ELSE 'NO'

    END AS OnSQLServer2008

    ,CASE value

         WHEN 0 THEN 'No'

         ELSE 'Yes'

     END AS [clr_enabled]

    ,(SELECT CASE compatibility_level WHEN 100 then 'Yes' ELSE 'No' END from sys.databases where name=db_name()) AS SQLServer2008CompatibilityMode

    FROM sys.configurations

    WHERE name = 'clr enabled'

       

OnSQLServer2008 clr_enabled SQLServer2008CompatibilityMode

--------------- ----------- ------------------------------

Yes             No          No

 

(1 row(s) affected)

       

select compatibility_level from sys.databases where name=db_name()

       

SELECT

SERVERPROPERTY('ProductVersion') AS ProductVersion,

SERVERPROPERTY('ProductLevel') AS ProductLevel,

SERVERPROPERTY('Edition') AS Edition,

SERVERPROPERTY('EngineEdition') AS EngineEdition;