How to Identify which .Net Framework Version used in SQL Server 2005/2008/2008 R2 versions

Posted by PandianS under Sql Server category on | Views : 5098
SQL Server 2005, 2008 & 2008 R2 are .Net framework enabled versions. So, we can identify the .Net Framework version using the following DMVs.
If Exists(Select 1 from sys.dm_clr_properties Where [Name] ='Version' And [Value] <>'')
Select [Value] '.Net Framework Version' from sys.dm_clr_properties Where [Name] ='Version'
Select product_version '.Net Framework Version' from sys.dm_os_loaded_modules
Where [name] Like '%MSCOREE.DLL'

Comments or Responses

Login to post response