Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Saturday, June 22, 2013 9:55 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 12:34 PM
Points: 1,865, Visits: 3,615
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.


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #1466470
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse