<div>
Hi vu3lmg,<br />
<br />
Please try this -<br />
<br />

<pre><code id="code-20-41977507-1">--
select * from sys.dm_clr_properties
--</code></pre>
<br />
and provide the output.
</div>


Hi vu3lmg,

Please try this -



--
select * from sys.dm_clr_properties
--


and provide the output.

<div>
Dear Pawan, below is the output from my SQL Server 2008<br />
<br />
<i>name &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;value<br />
---------------- &nbsp; &nbsp; --------------------------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />--<br />
directory &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;C:\Windows\Microsoft.NET\F<wbr />ramework64<wbr />\v2.0.5072<wbr />7\<br />
version &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; v2.0.50727<br />
state &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; CLR is initialized<br />
</i>
</div>


Dear Pawan, below is the output from my SQL Server 2008

name              value
----------------     --------------------------------------------------------------------------------------------------------------------------------
directory      C:\Windows\Microsoft.NET\Framework64\v2.0.50727\
version              v2.0.50727
state              CLR is initialized


<div>
As far as I know SQL Server 2012 is the first to support .NET framework 4.5
</div>


As far as I know SQL Server 2012 is the first to support .NET framework 4.5

<div>
<div class="content wysiwyg-content">
I have a web application running on .NET framework 4.5.2 which also uses CLR runtime on SQL server.<br />
If my DB is on SQL Server 2008, is it possible to make that CLR on the DB server use .NET framework 4.5.2 and not 3.5 ?<br />
<br />
Basically question is if SQL server 2008 can work with CLR on .NET framework 4.5.2 ?<br />
If the answer is &quot;YES&quot;; &nbsp;how do I make SQL Server 2008 to use framework 4.5.2
</div>
</div>


I have a web application running on .NET framework 4.5.2 which also uses CLR runtime on SQL server.
If my DB is on SQL Server 2008, is it possible to make that CLR on the DB server use .NET framework 4.5.2 and not 3.5 ?

Basically question is if SQL server 2008 can work with CLR on .NET framework 4.5.2 ?
If the answer is "YES";  how do I make SQL Server 2008 to use framework 4.5.2

SQL 2008 with .NET 4.5.2

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.