It is well documented here that when you update an assembly (that is not on the approved list) in the GAC that happens to be inside SQL 2005/2008, the SQLCLR will complain that could not load file or assembly. This is also a problem when moving a database to a new machine (that could have different versions of the assembies).
Is there a utility that I can run on a database, that compares the versions of the assemblies in the database to the versions in the GAC and runs ALTER ASSEMBLY's to fix this problem automatically?