SQLCLR in SQL 2008 doesn’t support .NET 4.0.
SQL Server 2008 installs with .NET 3.5 SP1, SQL Server 2005 installs with .NET 2.0. They can both use .NET 2.0 or 3.5 SP1 subject to limitation. No current version of SQL Server supports .NET 4.0. You must have the appropriate version of .NET installed on the target SQL Server machine.
http://msdn.microsoft.com/en-us/library/84b1se47.aspx
| Important |
| SQL Server 2005 and SQL Server 2008 only support SQL Server projects that were built with the 2.0, 3.0, or 3.5 version of the .NET Framework. If you try to deploy a SQL Server project to SQL Server 2005 or SQL Server 2008, an error appears: Deploy error (SQL01268): .NET SqlClient Data Provider: Msg 6218, Level 16, State 3, Line 1 CREATE ASSEMBLY for assembly 'AssemblyName' failed because assembly 'AssemblyName' failed verification. Check if the referenced assemblies are up-to-date and trusted (for external_access or unsafe) to execute in the database (where AssemblyName is the name of the assembly that you are deploying). |
