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

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'

1 comment: