The options in Management Studio
On Management studio Tools->Options->Query Execution->SQL Server there are options that are set and these prevail over the same options that are set on database level.
The Options at Database level
on management studio you right-click on a database and you can see what are the defaults for a number of options: (in yellow on the picture below)
using sys.databases you can get hold of these options using T_SQL.
The Options At Session Level
Using sys.dm_exec_sessions you can get hold of the options as they are set for the current session.
Is there a way to make sure the database setting will prevail over the management studio settings?
I thought about creating a plan, and use OPTION (USE PLAN) but that has other consequences that is beyond the scope of this question.