Interesujeme kako da napravim store proceduru u NET 4.5 i da je sacuvam na SQL serveru 2008R2... Ja kada odradim sve , ne prihvata mi Deploy Project (NE ZNAM IZ KOG RAZLOGA),a kada u SQL pokusam da kreiram assembli :
dobijem sledecu gresku :
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
Moze li mi neko reci u cemu je problem? Negde sam procitao da sql clr 4.5 moze da radi samo na sql 2012 ali nisam bas siguran u to ...
Pozdrav
Code:
create assembly Sql_Clr
from
'F:\IS-AutoSkola\Sql_Clr\bin\Debug\Sql_Clr.dll'
with permission_set = unsafe
Go
create assembly Sql_Clr
from
'F:\IS-AutoSkola\Sql_Clr\bin\Debug\Sql_Clr.dll'
with permission_set = unsafe
Go
dobijem sledecu gresku :
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
Moze li mi neko reci u cemu je problem? Negde sam procitao da sql clr 4.5 moze da radi samo na sql 2012 ali nisam bas siguran u to ...
Pozdrav