I recently migrated my DB from Sql Server 2008 to SQL 2016. When I tried connecting the DB to my application using SQL Login Functions and Procedures are giving type conversion Error with SQL Server 2016.
(The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.)
However, when executing them with windows login they are working fine.
This is happening with almost all functions and procedures.