Change Server Settings
- Right-click on your server in SQL Server Management Studio (SSMS) and choose properties (last option).
- Select the Connections page in the right-hand page.
Some connection options are already set.
- Select the check boxes in front of the settings ansi padding, ANSI NULLS, quoted identifier, and concat null yields null.
You can find a full description of the server settings in the technical document 'MS SQL Server <version> Installation and Configuration.pdf'.