System.InvalidOperationException: Cannot load dynamically generated serialization assembly. In some hosting environments assembly load functionality is restricted, consider using pre-generated serializer. Please see inner exception for more information. ---> System.IO.FileLoadException: LoadFrom(), LoadFile(), Load(byte[]) and LoadModule() have been disabled by the host.

Error msg is due to a dll that references a web service or has web service proxy class in it that has asyc references.

create proxy class from wsdl and add it to your sql server project.  Deploy the project with external access set for dll.  include XmlSerializers.dll with save access.

Using Web services and Xml Serialization in CLR Integration info on blog post here