Previous Topic

Next Topic

Inhoudsopgave

Book Index

Configure SQL Server Management Studio

You must change the configuration of SQL Server Management Studio (SSMS). SSMS defines defaults for the connection parameters it uses when making a connection with SQL Server.

  1. In the Tools menu, click Options.
  2. In the left-hand pane, open Query Execution, open SQL Server and then click Advanced. In the right-hand pane, check the box of the SET CONCAT_NULL_YIELDS_NULL field.
  3. In the left-hand pane, click ANSI. In the right-hand pane, check the boxes of the fields SET QUOTED_IDENTIFIER, SET ANSI_PADDING, and SET ANSI_NULLS. Then click OK.