Thursday, 22 August 2013

How to check SQL Server instance Target Framework

When you uses .Net components in SQL server.The component build framework should be compatible with SQL server target framework.If it is not the below error occurred

The following error might appear if you deploy a SQL CLR project that was built for a version of the .NET Framework that is incompatible with the target instance of SQL Server.

So you need to check SQL Server target framework.

select * from sys.dm_clr_properties 

To resolve this error, set target framework of your projects compatible  with this result accordingly.

No comments:

Post a Comment

Please leave a comment for this post