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

sqlttown

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;

Victoria W

Hi @sqlttown

Our support doesn't currenty extend to Fabric Warehouses.