>>What problem you're getting with the second setting? Also play with SET ANSI_WARNINGS
>>
>>I googled on ANSI_NULL_DEFAULT and it returns lots of useful info.
>>
>>
http://msdn2.microsoft.com/en-us/library/ms187375.aspx>>
>>The syntax is
>>
>>SET ANSI_NULL_DFLT_ON {ON | OFF}
>
>SET_ANSI_WARNINGS has no effect.
>
>The syntax for ANSI_NULL_DFLT_ON is accepted but this doesn't change anything. I am curious to know however that the interface recognizes the other spelling I did but reports an error on execution.
Please post the failing command. Perhaps it has nothing to do with the NULL settings.
BTW, I updated my original reply a bit (included more info).
Also please post the exact error.
If it's not broken, fix it until it is.
My Blog