SQL error: incorrect settings: 'QUOTED_IDENTIFIER'
We getting a sql error in our voucher posting process.
Partial error message pasted below:
file: e:\pt857p07b_1905200503-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1725 Error Position: 0 Return: 8601 - [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]INSERT failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or f
Failed SQL stmt: INSERT INTO
Our DBA has run of ideas about why would we get this SQL error.
Our settings for : 'QUOTED_IDENTIFIER' are set to ON (enabled) as recommended by GSC.