>>Try SET ANSI_WARNINGS OFF.
>
>But, I would need something at the SQL Server level as I do not want to pass this command for every SQL I will do. Is there such a setting in the interface?

I believe you can set this setting on a database level. Look at various database options.