Is anyone getting errors running the script.
It starts throwing the following errors in our environment, even though it sets IDENTITY_INSERT to on in the script for this table
(1 row affected)Msg 544, Level 16, State 1, Line 14Cannot insert explicit ...
Been through this a couple of times and it is easier to just stand up a new SQL environment. Then you can either backup the databases and restore them to the new SQL server, or use MS Data Migration Assistant to migrate all the SQL databases and logi...
Perfect, worked for me and the Datawarehouse export has completed on all our tenants, so that was a win. Now to look into the ARL issue I have and raise another call with the support guys.
ANOTHER UPDATE...Forget the last update, it is still failing with it set to 0, so I have set it back again to 1.Will have to open a support call after all and see if the support guys can sort it out.
UPDATE....It was a problem with the script as we a...