>>Hmmm, may be it's another setting then (and actually I believe it is). I'm in the library right now, can not check which exact setting is responsible.
>
>That setting is effetive if I write it in the script window. But, that would mean I would have to pass it in all my SQL command which is something I would like to avoid and rely on the interface setting.
It is strange and it may be a bug in SQL Server. If we have this setting for the database, why do we need to apply it again in every query? Doesn't sound logical to me.
If it's not broken, fix it until it is.
My Blog