SQLCLR using the wrong version of the .NET Framework

Posted by Tobias Rundbom on Stack Overflow See other posts from Stack Overflow or by Tobias Rundbom
Published on 2010-05-06T13:46:24Z Indexed on 2010/05/06 14:18 UTC
Read the original article Hit count: 499

During a recent restart of our development server the SQL Server started using .NET 4.0 for the SQLCLR. This means that nothing using the CLR in SQL works, or at least that's my understanding by reading these sources:

http://software.intel.com/en-us/blogs/2009/10/16/sql-server-2008-sqlclr-net-framework-version/

www.sqlskills.com/BLOGS/BOBB/post/On-SQL-Server-and-NET-40.aspx

All we get are error messages of this type: Msg 6517, Level 16, State 1, Line 1 Failed to create AppDomain "xxx.dbo[ddl].3". Method's type signature is not Interop compatible.

Does anyone know how to solve this or how we can force SQL Server CLR to use an earlier version of the Framework?

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about sqlclr