>>See SET ANSI_WARNINGS
>
>Thanks, I see that in the script mode I can set it off and that it will allow me to insert. But, assuming I would like to do that from the code, which is not the case, but, by curiosity, this would mean I would have to include that whereever I am doing some SQL commands. In other words, from the SSMS interface, would there be a setting that could be done at that level?

SSMS doesn't seem to respect a server or DB default settings. I don't know if it can be configured/overriten somewhere.