chillsdon (8/14/2013)
Try making the database trustworthy first:ALTER DATABASE <DBName> SET TRUSTWORTHY ON
I had to do this when creating a CLR procedure that accessed the file system, and so then also had to create the assembly with PERMISSION_SET = EXTERNAL_ACCESS.
I don't know why but implicit privs between databases give me the shivers.
--Jeff Moden
Change is inevitable... Change for the better is not.