Error on CreateTables.sql in Linux self hosted installation
Question:
I am trying to install Jitbit Helpdesk on Linux SQL Server and get following error when creating SQL tables. What might cause this issue?
CREATE INDEX 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 filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.
Answer:
If you execute the script sqlcmd, not via SSMS or other GUI-tools - then specify the "
If you execute the script sqlcmd, not via SSMS or other GUI-tools - then specify the "
-I" flag like described in this answer https://stackoverflow.com/a/51201270/56621