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.