You cannot use the OPTION clause in views. See this link.

The SELECT clauses in a view definition cannot include the following:

• An ORDER BY clause, unless there is also...

Try this:

DROP TABLE IF EXISTS #Run;
DROP TABLE IF EXISTS #RunControlClient;
DROP TABLE IF EXISTS #SQLServerDatabase;

CREATE TABLE #Run
(
    RunID INT NOT NULL PRIMARY KEY CLUSTERED
 ...

Is this a many-to-many join?

P.Tracker_PSYH = Z.ZATS_PSYH

Who is this guy?

PS, the logouts happen to me too.

SSISDB is...

We can't see your tables or your data, so I'm not sure how you expect us to be able to refine your unformatted SQL.

Please post some consumable code, along with...

One obvious way is to disable the index & then rebuild it, once the update is complete. I presume you're trying to avoid that?

A general answer to what? You haven't asked a question.

A quick example:

DECLARE @Who TABLE
(
    SPID CHAR(5)
   ,Status NVARCHAR(50)
   ,Login NVARCHAR(50)
 ...

Can you use a table variable?

I think you'll need recursion to solve this. Try running the following:

DROP TABLE IF EXISTS #table2;

CREATE TABLE #table2
(
    id INT NOT NULL --PRIMARY KEY...

NOT LIKE '836%'

works. If you think it doesn't, please provide a query which we can run to prove otherwise.

Note also that SSISDB does not contain any jobs, merely packages, logs, environments and configurations.

Do you have the Master Key from the original server? That is, the key used to encrypt (some of) the data inside SSISDB?

Or maybe this?

a) Users are querying table set A via synonyms

b) ETL process loads table set B with data from file1

c) ETL process switches synonyms to point to table set...