The default deployment script for SQL CLR objects in VS2010 seems to require one to set the target database to SET TRUSTWORTHY ON and tries to enable vardecimal storage at the database level.
On our landscape we prefer to SET TRUSTWORTHY OFF on our databases. Also, one cannot enable vardecimal storage on system databases. We have some TVFs that we deploy to master.
It would be nice to be able to have the script be properly generated instead of having to modify it with each build. For now, I have abandoned the Deploy feature and manually deploy my CLR objects.
How do I customize the autogenerated deployment script? Is there a way?