Search code examples
sql-servervisual-studio-2010sql-server-2008sqlclr

Set SQL CLR assembly PERMISSION_SET in Visual Studio


Is it possible for me to have the deployment / scripts within Visual Studio generate my assembly with "PERMISSION_SET" set to "EXTERNAL_ACCESS" instead of "SAFE". I can obviously build the project and then modify the script, but I would like to have that be a setting so I can re-build then deploy to my Development instance.

Probably something I am looking over, but I can't seem to find where I could set that build property for the assembly creation.

Thanks,

S


Solution

  • If found the setting in Visual Studio. You can go to Project Properties -> Database here you select the Database to deploy to along with the Permission level of the CLR Assembly.

    --S