How to repair Microsoft.SqlServer.Types assembly
After searching online a lot, I see the only option to fix that type of corruption is to recreate the database objects and move all the data.

(or restore a backup if available)