Chris,

I actually found the exact same issue using the sp_browsereplcmds. However, when I deleted the duplicate commands with type -2147483618 some (but not all) of the affected publications popping up...

We're having a very similar issue, except it is on a new setup of Replication.

I would caution that if you have any deprecated syntax in the database's views and stored procs (SQL-89 joins for example), changing the compatibility mode can cause them to break....

Unfortunately, to add an Execute As clause, I would need to wrap the In Line SQL in a stored proc or function. If that's the case, I may as well...