ExecuteDrillthroughAndFixColumns - partially trusted callers

Topics: Developer Forum
Nov 4, 2009 at 10:57 AM

When I drillthrough after adding ‘call ASSP.ExecuteDrillthroughAndFixColumns(”’ + … + ‘”)”, I get an error “the assembly does not allow partially trusted callers”. What do I do wrong? Before adding the ‘FixColumns’ it worked fine.

Nov 5, 2009 at 7:20 AM

If you check the home page (http://asstoredprocedures.codeplex.com/) it shows which sproc calls require the assembly be registered as unrestricted. The particular one needs to open an external connection, so that's not allowed in assemblies registered as safe. (To be honest, I haven't tested whether that sproc will work if deployed with "External access" permissions instead of safe (and instead of unrestricted permissions). Regardless, fix that setting. More here: