Getting error Table hint NOLOCK is not allowed
When I attempt to connect to our Azure Fabric SQL Database with a 3rd Party application, (not SSMS) I get the error:
Table hint NOLOCK is not allowed
Can someone let me know how to fix this issue? Is it possible to fix this issue on the Azure Fabric SQL DB? Or does it need to fixed on the 3rd Party application?
Solution
Fabric SQL Database supports NOLOCK, but the SQL Analytics endpoint does not.
So you've hooked the third-party app to the wrong TDS endpoint. You want the endpoint that ends in .database.fabric.microsoft.com not .datawarehouse.fabric.microsoft.com.
- Getting InsufficientPrivileges / PrincipalTypeNotSupported error while calling Fabric REST API's
- Getting error Table hint NOLOCK is not allowed
- Connect Microsoft Fabrics Warehouse from PHP (here using Doctrine DBAL)
- Fabric Notebook running into error while using TSfresh for feature extraction
- Unable to locate the Debug tab in Azure Fabric Pipelines
- How can we grant access to a Schema present in Fabric Datawarehouse to all users present in Azure AD Group?
- Error renaming a column in SQL Server with sp_rename in Microsoft Fabric
- How to grant permissions to my application to use Microsoft Fabric services?
- Is it possible modify the definition of a DataPipeline using the API? [Microsoft Fabric]
- Azure MS Fabric Public IP Address
- Getting Authentication failed error while connecting with MS Fabric data Warehouse Using Node js and Python
- Converting binary to decimal in Kusto
- Error while Creating MS Fabric workspace using API
- F&O tables are not created in Fabric
- REST API with Post Method as source in ADF Data flow
- Script to call the MS Fabric -Git update From Git API
- Unable to print access token for Fabric REST API in ADO
- Ways to automate deployment to ADLS and its containers using ADO
- Getting error while creating access token using OAuth 2.0 for MS Fabric
- Benefits of using Fabric-ADO Pipeline over Inbuilt MS Fabric Deployment pipeline
- MS Fabric project Deployment using Azure Pipelines
- Cannot Find Fabric In Azure Portal under App Registrations
- PowerBI get data from different tenant SQL database
- Fabric-Rest API: why updateFromGit is returning invalid git hash or missing options?
- DAX query to retrieve all the tables in a dataset
- Adding Keys to key value pairs in ADF JSON Processing
- Reading multiple Parquet files in PySpark notebook
- Write a df from a Microsoft Fabric notebook into my local disk folder
- Golden Gate Replicate to Mirrored Database in Microsoft Fabric - Azure Identity Error
- How to Grant Access to an Entire Azure AD Group in DWH Fabric?