• So, following is what is the nutshell of our discussion:

    1. Whenever, we code execute commands in SSMS. It doesn't matter what user option is selected in default connections properties. Session level setting override default connection properties.

    2. User options take into effect when ever code is executed from Application within application code like .net/.java/etc.

    Please confirm. And thanks a lot for giving your time to this post.

    Regards
    VG