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



Tools->Options->Query Execution->SQL Server->ANSI