There can be flaky issues if you lose an account that owns things. It's worth doing some cleanup, and saving these scripts. You'll use them again.

I'd change the...

Excellent. Glad to hear it and hope everything else is working great.

Not sure and not debugging. We'll be cutting over to a new site soon, so it doesn't matter for now

They do have a SQL interface, and I'm not sure if this is good or bad. It might be that SQL is just a better way of querying, or at...

Completely agree. This is one area that I think we do poorly as an industry, and really, the controls for doing this better are cumbersome.

I'd really like "sa"/sysadmin...

Good luck. I haven't had issues here, but I do see the docs mentioning that setting to read/write should make clients prefer the secondary.

Apologies for this. I misplaced the testing script, but only 1 should be allowed. 

Not sure what I was thinking.

done

The short answer is you cannot encrypt code. You can obfuscate it with the "WITH ENCRYPTION" option, but this is easily reversable, as pointed out above. SQL Compare does this...

First, don't use profiler anymore. Use Extended Events or the xEvent Profiler to watch things.

Second, do you have the primary set for read/write? This should limit the read...

I would write this more compactly
UPDATE  WMWHSE1.LOTATTRIBUTE
  SET LOTTABLE05 =     I.LOTTABLE05
  FROM WMWHSE1.ITRN I

   JOIN WMWHSE1.LOTATTRIBUTE L

    ON I.LOTTABLE06 = L.LOTTABLE06