I think that what is going on here is that the properties of the connection are over-riding the DB option - the connection supporting a QA or SMSS query window always has concat null yields null ON for the connection until it is overridden by a SET statement. The db option is only relevant for connections where concat null yields null is not set for the connection, so it is not relevant to QA or SMSS query windows.