• jordanovskibojan 74807 (5/5/2013)


    Hello guys,

    I have problem that I can't resolve ..

    I want to make simple store procedure using .net 4.5 and I cant deploy my project ..

    I have 3 projects in my solution,and one of them is Sql_Clr (Sql Server Database Project) which can't deploy.. I can build solution,but when I click deploy nothing happens..

    In net 3.5 everything was fine...

    Otherwise,when I try to create assembly in SQL 2008R2 like this:

    create assembly Sql_Clr

    from

    'F:\IS-AutoSkola\Sql_Clr\bin\Debug\Sql_Clr.dll'

    with permission_set = unsafe

    Go

    it shows me an error:

    CREATE ASSEMBLY for assembly 'Sql_Clr' failed because assembly 'Sql_Clr' failed verification.

    Check if the referenced assemblies are up-to-date and trusted (for external_access or unsafe) to execute in the database.

    CLR Verifier error messages if any will follow this message

    Any help is appreciated .. 🙂

    SQL 2005 only supports CLR objects targeting the .NET 2.0 Runtime, i.e. built for .NET 2.0, 3.0 or 3.5 Framework.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato