i've got c# code running on a thread that is processing rows when its sent them. everything is working beautifully. but i need to call it from SQL. the only way i know how to do this is compile the csharp code into a DLL then create an assembly out of the dynamic link library then create a stored proc outta that. i did all this and now have a stored procedure that is referencing a certain method in my csharp code that in turns runs everything.
but when i try to execute the code i get this terribly frustrating error.
A .NET Framework error occurred during execution of user defined routine or aggregate 'trig':
System.Security.HostProtectionException: Attempted to perform an operation that was forbidden by the CLR host.
The protected resources (only available with full trust) were: All
The demanded resources were: UI