we want to insert data to a table using an stored procedure which works as the api endpoint. when running this stored procedure directly in SQLManagementStudio everything works well. but when we using this api-endpoint with e.g. Insomnia to test, we receive this error:
Failed to call database stored procedure.\nSQLSTATE[HY000]: General error: 20018 INSERT failed because the following SET options have incorrect settings: ‘CONCAT_NULL_YIELDS_NULL, ANSI_PADDING’. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations. [20018] (severity 16)
the table we are inserting data, has an index which uses these options:
SET CONCAT_NULL_YIELDS_NULL, ANSI_PADDING ON
we believe that this option is set when connected to the database. So is it possible to pass this options along with the Connection?
does somebody has any idea or the same problem?
thanks timo