INSERT failed because the following SET parameters have incorrect settings: 'QUOTED_IDENTIFIER'

Question

We sometimes get the message below when executing a stored procedure, after which, without any changes, deleting and re-executing the stored procedure works fine.

DBCORE INSERT error because the following SET parameters have incorrect settings: "QUOTED_IDENTIFIER". Ensure that the SET parameters are correct for use with indexed views and / or indexes for computed columns and / or filtered indexes and / or query notifications and / or methods such as XML data and / or spatial index operations.

Please help us understand this.

Answer 1

QUOTED_IDENTIFIER "" , , , . , , QUOTED_IDENTIFIER OFF /QUOTED_IDENTIFIER OFF , .

QUOTED_IDENTIFIER ON ANSI_NULLS ON .

Answer 2

, MS SQL.

GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON

Answer 3

-I sqlcmd.exe .

Answer 4

- Visual Studio, . " ", > " " " ".

( ) , .

This will only fix the problem if you have changes to the procedure as ever; comparison of the scheme and subsequent update will not change QUOTED_IDENTIFIERin the stored procedure, unless changes are made to the body of the procedure. This will prevent the problem from recurring during a subsequent schema update.