• Curious about the CREATE ASSEMBLY command - does it just create a pointer, or does it actually compile the code into the SQL server?  I'm trying to imagine the scenario of when you need to edit the CLR method - do you then need to drop the current assembly, and then rebuild the assembly and internal functions etc?   Seems like a pain.  If the CREATE ASSEMBLY just pointed to the dll then it seems like it would be easy.