I ran into the issue on SQL server.:
INSERT failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.
I checked all stored procedures: it is "
SET QUOTED_IDENTIFIER OFF
"
the question: I didn't set the value. the value should be ON by default.
I remembered I run sql script by a sqlcmd.exe , that is the reason.
because the "queoted indentifier " is off by default.
so I rerun the scripts via the following script:
sqlcmd.exe -S "servername" -I -i "sql cript"
The "-I" is to enable the quoted indentifier to ON.