>>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?

There's such setting on DB level but it is most likely has been overriten by whatever drover/provider you're using to access SQL Server. See if you cann change it when you create a connection to SQL Server.