Follow us on Twitter!
One mans freedom fighter, another's terrorist.
Thursday, September 29, 2016
Navigation
Home
 Find:
 Information:
Learn
Communicate
Submit
Shop
Challenges
 Exploit:
 Programming:
 Think:
 Track:
 Patch:
 Other:
 Need Help?
Other
Members Online
Total Online: 18
Guests Online: 17
Members Online: 1

Registered Members: 95756
Newest Member: cantbetraced100252
Latest Articles
View Thread

HellBound Hackers | Computer General | Webmasters Lounge

Author

RE: SQL Problem...Show Your Mastery


Member

Your avatar

Posts:
Location:
Joined: 01.01.70
Rank:
Guest
Posted on 11-06-08 16:01
allright scratch all the service broker crap..

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

System.Security.HostProtectionException:
at System.Security.CodeAccessSecurityEngine.ThrowSecurityException(Assembly asm, PermissionSet granted, PermissionSet refused, RuntimeMethodHandle rmh, SecurityAction action, Object demand, IPermission permThatFailed)
at System.Security.CodeAccessSecurityEngine.ThrowSecurityException(Object assemblyOrString, PermissionSet granted, PermissionSet refused, RuntimeMethodHandle rmh, SecurityAction action, Object demand, IPermission permThatFailed)
at System.Security.CodeAccessSecurityEngine.CheckSetHelper(PermissionSet grants, PermissionSet refused, PermissionSet demands, RuntimeMethodHandle rmh, Object assemblyOrString, SecurityAction action, Boolean throwException)
at System.Security.CodeAccessSecurityEngine.CheckSetHelper(CompressedStack cs, PermissionSet grants, PermissionSet refused, PermissionSet demands, RuntimeMethodHandle rmh, Assembly asm, SecurityAction action)
at FileTrigger..ctor(SqlConnection conn, String cmd)
at FileTrigger.run(String cmd)

anybody else ever get this lil guy? thanks in advance.