getting error - Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Setting QUOTED_IDENTIFIER to 'OFF' is not supported..

Dhanya Gopan 0 Reputation points
2023-03-31T13:46:37.43+00:00

when trying to execute procedure in synapse dedicated pool from local command prompt as attached and getting error as - Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Setting QUOTED_IDENTIFIER to 'OFF' is not supported..

Is this related to any configuration to do in synapse dedicated pool?

User's image

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,369 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AnnuKumari-MSFT 30,676 Reputation points Microsoft Employee
    2023-04-03T09:09:50.7066667+00:00

    @Dhanya Gopan ,

    Welcome to Microsoft Q&A platform and thanks for posting your question here.

    From the description of your question, I understand that you are facing an error "Setting QUOTED_IDENTIFIER to 'OFF' is not supported" while executing a stored procedure in dedicated sql pool. Please let me know if that is not the correct understanding.

    To resolve this issue, you can try setting the QUOTED_IDENTIFIER setting to ON . This should enable the use of ANSI-quoted identifiers in your script and resolve the error you are seeing. You can do this by adding the following line at the beginning of your script:

    SET QUOTED_IDENTIFIER ON;

    Hope it helps. Please accept the answer if it was helpful. Thankyou.