Deploying External and Unsafe SQL CLR Functions
ElementZero | January 6, 2010If you ever have to deploy a SQL CLR Function that is not using Safe Permissions, then you may run into a roadblock where you get the error
CREATE ASSEMBLY for assembly ‘MyProject’ failed because assembly ‘MyProject’ is not authorized for PERMISSION_SET = EXTERNAL_ACCESS.
The assembly is authorized when either of the following is true:
the database owner (DBO) has EXTERNAL ACCESS ASSEMBLY permission and the database has… Continue reading





