net framework version required for assembly in sqlserver

Question

hello in visual studio 2010 to create database project SQLCLR, says sqlserver 2005 and sqlserver 2008 using net 3.5, that depends on exactly this ...

what if I have sqlserver 2012, I can use net 4.0, 3.5

Answer 1

Hello,

You can query the supported CLR version with:

SELECT SERVERPROPERTY(N'BuildClrVersion')

For SQL Server 2012 you get v4.0.30319, for other versions v2.0.50727

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 2

Yes but why? with net framework 3.5, I can run in sqlserver clr 2005/2008
I find that net framework 3.5 and 2.0 use the clr 2.0, and net framework 4.0 uses
clr 4.0

Another question when installing sqlserver, also installs their net framework it was done ..

Answer 3

Yes but why? with net framework 3.5, I can run in sqlserver clr 2005/2008
I find that net framework 3.5 and 2.0 use the clr 2.0, and net framework 4.0 uses
clr 4.0

Another question when installing sqlserver, also installs their net framework it was done ..

What's your question? Why net framework 4.0 uses clr 4.0? It's by design!

Answer 4

i understand all in the link:

http://msdn.microsoft.com/en-us/library/8bs2ecf4.aspx