This question already has an answer here:

I restored a backup database from a 2008r2 server to a brand new instance of sql server 2017. When I run the same stored procedure, I am now getting type conversion warnings in the execution plan that don't appear when running in 2008r2. Is there a setting that disables these warnings that may have been set in the old server or am I missing something? I ran the database migration assistant and it said no issues for the migration.

marked as duplicate by Brent Ozar sql-server Feb 8 at 18:35

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.