Apparently with some data types or some SQL versions, some columns may be duplicated with a sysname datatype.  I've submitted an update to the original script, but it may take a few days for the update to be approved.

In the Results CTE

 FROM     tempdb.sys.columns AS C
  INNER JOIN   tempdb.sys.types AS T2
   ON C.system_type_id = T2.system_type_id 

change the ON clause above to this

ON c.user_type_id = t2.user_type_id