Configuring the Management Studio editor
In the
Tools
menu, click
Options
.
In the left-hand pane, open
Query Execution
, open
SQL Server
and then click
ANSI
. In the right-hand pane, empty the field
SET ANSI_NULL_DFLT_ON,
and
SET ANSI_WARNINGS
. Then click
OK
.