The plot thickens a bit. After further analysis, Most, but not all, rows that have a three letter word/prefix followed by a space or special character at the...

The collations and sort orders match across the servers. They are on the same Version, SP, CU.

I am having a new issue that is similar. However, mine appears to be unrelated to SQLAgent. My query fails when executing in SSMS. This is on...