How can we help you today? How can we help you today?

How can I work around warning: "Table hint NOLOCK is not allowed" when comparing Fabric warehouses ?

I am trying to compare 2 Microsoft Fabric warehouse databases but I am receiving the error that it cannot register the source and target databases due to "Table hint NOLOCK is not allowed".

Is there a command I can run on the warehouse databases or an option within SQL Data Compare that I can adjust to permit the comparison to run ?

I tried running the SQL statement:
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
ben.herring
0

Comments

1 comment

Sort by
  • Victoria W
    Hi @sqlttown

    Our support doesn't currenty extend to Fabric Warehouses.
    Victoria W
    0

Add comment

Please sign in to leave a comment.