Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SQLCLR assemblies - how can I find out .NET version of each? Expand / Collapse
Posted Saturday, June 22, 2013 9:55 AM


Group: General Forum Members
Last Login: Wednesday, November 30, 2016 2:47 PM
Points: 1,869, Visits: 3,728
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

name value
directory C:\Windows\Microsoft.NET\Framework64\v4.0.30319\
version v4.0.30319
state CLR is initialized

Thank you for any responses.

Persisting SQL Server Index-Usage Statistics with MERGE
Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #1466470
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse