I'm not sure I understand why you would even ask that question.   The purpose of replication is to keep a working copy of a database current, and usually in near...

You're welcome!

Might as well go ahead and do the trace. 🙂  Indeed those older versions don't have much applicability any more.

How about we try the following:
WITH DimTables AS (

    SELECT t.[name]        AS TableName
        , s.[name]        AS SchemaName
        , t.[Object_ID]    AS TableID
    FROM DWH_Staging.sys.tables AS t
        INNER JOIN DWH_Staging.sys.schemas AS s
            ON...

20 Seconds to count ALL the table's columns number of distinct values ?   You might not have all that much data, or just not that many overall columns.   I would...

Just wanted to look at an alternative that appears to perform better:
--Sample Tables
CREATE TABLE #Table1 (ID int PRIMARY KEY CLUSTERED, Depth int);
CREATE TABLE #Table2 (ID int, Vegetable varchar(10), Depth int,...

You could do something like this and then copy and paste the SQL_TEXT column into SSMS for execution, and you could modify the WHERE clause to suit your objectives:
SELECT...

A slightly more compact version:UPDATE a
SET a.source='CP',
    a.PREVENTCOPY = L.PREVENTCOPY,
    a.PREVENTPRINT = L.PREVENTPRINT,
    a.ISAMOVAR = L.ISAMOVAR,
    a.ID = L.ID,
    a.MREADONLY = L.MREADONLY,
    a.FIELDLEN = L.FIELDLEN,
    a.EDITTYPE = L.EDITTYPE,
    a.FIELDTITLE...

Have you validated that the data types in your destination table are a match for the same exact table that is the destination snapshot replica ?   Next step is to...

I have to agree with John Mitchell - your query has a few holes in it.   You have no table alias "lc", so that's just not right.  I also see...