https://support.microsoft.com/en-au/topic/kb4054398-fix-invalid-comparison-due-to-no-collation-retail-assert-occurs-in-sql-server-2014-2016-and-2017-d400a8c1-a80b-d44c-87ff-2d5f3ee71921
KB4054398 - FIX: "Invalid comparison due to NO COLLATION" retail assert occurs in SQL Server 2014,...
Describes an issue in which a retail assert occurs that states "Invalid comparison due to NO COLLATION" in SQL server 2014 , 2016, and 2017.