My personal preference is to build a new server with New OS and A New install of SQL Server, then migrate the databases using backup and restore, or even simply...
Interestingly it did find two columns name name collation_name tblAlarmHistory AlarmMessage SQL_Latin1_General_CP1_CI_AS tblAlarmHistory Note SQL_Latin1_General_CP1_CI_AS