Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Set SQL CLR assembly PERMISSION_SET in Visual Studio

Answered Set SQL CLR assembly PERMISSION_SET in Visual Studio

  • Wednesday, January 25, 2012 2:03 AM
     
     
    Sign In to Vote
    0

    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,

     

All Replies

  • Wednesday, January 25, 2012 3:38 AM
    Moderator
     
     Answered
    Sign In to Vote
    0
    It’s in the project properties,  Database page, Permission Level.
     
    Cheers,  Bob
    • Marked As Answer by BenHamiin Wednesday, January 25, 2012 5:11 PM
    •  
     
  • Wednesday, January 25, 2012 5:11 PM
     
     
    Sign In to Vote
    0

    Sweet!  Thanks Bob.

     

    --B