When I run a checkdb('mydb') this is the only error message printed.
Msg 8992, Level 16, State 1, Line 1 Check Catalog Msg 3857, State 1: The attribute (clr_name=NULL) is required but is missing for row (assembly_id=1) in sys.assemblies.
It is referring to 'Microsoft.SqlServer.Types' I do see that in the this db the clr_name is blank. but under the master db there is a value in there.
I tried to drop or alter the assembly to add this value but its restricted.
btw, this db was updated lately from sql-server 2005 to 2008R2.