Configuring the Management Studio editor

1. In the Tools menu, click Options.
2. 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.