none
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
    Monday, October 21, 2013 4:17 AM

Answers

All replies

  • 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]

    Monday, October 21, 2013 8:25 AM
  • 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 ..
    Tuesday, October 22, 2013 3:56 AM
  • 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!
    Thursday, October 31, 2013 1:11 AM
    • Marked as answer by neonash Thursday, October 31, 2013 4:21 AM
    Thursday, October 31, 2013 4:21 AM