Configuring the Management Studio editor

1. In the Tools menu, click Options.
2. In the left-hand pane, click Query Execution, click SQL Server and then click Advanced. In the right-hand pane, empty the SET CONCAT_NULL_YIELDS_NULL field.
3. In the left-hand pane, click ANSI. In the right-hand pane, empty the field SET QUOTED_IDENTIFIER, SET ANSI_NULL_DFLT_ON, SET ANSI_PADDING, SET ANSI_WARNINGS, and SET ANSI_NULLS. Then click OK.