title: Alter assembly in SQL Server
body: <p>we have database with some table-valued functions writen in C#. I have database project in visual studio, where I use "Deploy" action from Solution Explorer. However, when I want "alter" assembly and functions on testing database server from my developing database server I must manually (now semi-scripted) drop functions and assembly, then create assembly and create functions.</p>
  
  <p>In 99% cases we don't change interface (function names, column names, column types, etc...).</p>
  
  <p>Is there some easy way how to alter assembly and related functions/procedures?
  Thanks</p>