I'm trying to find out with which .NET version each of the CLR assemblies in my SQL-2012 instance were built, but I am unable to find this info.
For example, were the deployed assemblies built with .NET 2, 3 or 4?
Views, such as sys.assemblies, sys.dm_clr_appdomains, sys.dm_clr_loaded_assemblies do not seem to give me this info.
My CLR is on version 4.0 (SQL 2012):
select * from sys.dm_clr_properties
namevalue
------------------------------------------------------------
directoryC:\Windows\Microsoft.NET\Framework64\v4.0.30319\
versionv4.0.30319
stateCLR is initialized
Thank you for any responses.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]