Tuesday, May 15, 2012 7:36 AM
There is are requirement of deploying .NET 4.0 library to SQL Server SP1.
This requirement is arised because, recently the library which needs to be deployed is migrated to .NET 4.0 from 2.0 assembly and after migrating from 2.0 to 4.0 the problem occurs.
Is ther a way/workaround such that .NET 4.0 assembly can be deployed to SQL Server 2008 SP1.
Version of SQL:
Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86) Mar 29 2009 10:27:29 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2).
I looked into related posts, but they specified that SQL Server 2008 Express with SP1 is shipped supporting the requirement. Can please let me know is there any workaround for standard version also???
Thanks in advance.
Tuesday, May 15, 2012 8:42 AM
SQL Server 2008 (R1 and R2) only supports CLR assemblies up to .NET Framework 3.5, whereas SQL 2012 supports .NET Framework 4.
- Marked As Answer by Bob BeaucheminMVP, Moderator Wednesday, May 16, 2012 5:36 PM
Tuesday, May 15, 2012 9:05 AM
So there is no way in using the .NET 4.0 libraries.
Wednesday, May 16, 2012 7:58 AMModerator
This article on the SQL Server Express blog suggests there will be no .NET 4 SQLCLR in SQL Server 2008 (assuming that the logic extends to the other editions).
Please remember to mark the replies as answers if they help and unmark them if they provide no help.