title: How do I update an assembly and its dependent assemblies in MS-SQL?
body: <p>This is the situation:</p>
  
  <p>I have a Trigger.dll and a Trigger.XmlSerializer.dll. </p>
  
  <p>I use CREATE ASSEMBLY to register them in MSSQL.</p>
  
  <p>Now, I have compiled new versions of both.</p>
  
  <p>I want to use ALTER ASSEMBLY to update them, however you can only update one at a time.  If you try to update one that has a dependency, it complains.  What's the trick to doing this?</p>
  
  <p>I don't want to drop and recreate as I have to then drop all the triggers, etc. and there is database downtime.</p>