You do not need a temp table.

This should work

CREATE VIEW dbo.YourViewName
WITH SCHEMABINDING
AS

    SELECT issue_number,
        type_code,
        CASE
            WHEN alt_type_code...

No, no, no. 

In the VMNew, you are starting SSMS, and connecting to VMOriginal???
That's your first mistake.  
When you click connect, database engine, in the server name...

Or Pittsburgh

There's little sense in shrinking tempdb over and over again.  This may be a viable option of this was a one-time data load.

The question I have is what...

Let's assume that one of the 6 admins may be the culprit.  There is very little that you can do that they cannot undo.  Unless you can put auditing on...

It sounds as if the design of your table may not be correct.  These are items, possibly an inventory system????

The combination of the manufacturers code, which you may...

The bigger question is why do you ask?  What were you thinking of doing?

Anyone else ever do this?
https://www.sqlshack.com/how-to-spoof-production-environment-resources-for-performance-tuning/#.WRr9Do_GEfw.linkedin

Looks rather interesting...