Steve, something changed in the notification emails?
I don't think I shout be getting users' emails instead of username.

If there's a second file in primary, new pages should be allocated with proportional fill, meaning the full file gets no pages and the empty gets all new pages. you...

DDL triggers are AFTER triggers, meaning they fire within the transaction *after* the changes have been made. So at that point, there is no record in sys.databases for the DB...

One option:
Instead of DISTINCT

GROUP BY <primary key> and then decide what you want to do with each of the other columns (MIN, MAX or other aggregation)

Google search for "DReplay Extended Events" First result:
https://borishristov.com/blog/t-sql-tuesday-67-extended-events-and-distributed-replay/

That shouldn't even compile, because this does not exist as a table: [EDIImpTbl_ComputerInventory].[Service Tag]

JOIN #Temp ON ...
Then you can reference it further down. Same as any other table.

You can't say
FROM Customers inner join OrderDetails on Customers.ID = Orders.CustomerID, same...

There is a way to convert an extended events output to trace so that DReplay can read it. Don't have links offhand, google should turn them up.

sp_statement_completed & sql_statement_completed and look for sp_executesql or EXEC with brackets.
Or the entire batch with sql_batch_completed and RPC completed. Eitherway, a second filter is necessary, and probably better to...

SELECT 1 means just that. Select the literal value 1. It's used in EXISTS because SQL doesn't care about the columns in an EXISTS. You could replace it with SELECT...

What do you mean 'it can't fetch state_desc'?