This is a classic.
I've seen this in environments where someone is trying desperately to resolve SQL Server performance issues. Out of the blue, linked server/DTC queries will begin to fail with the following error message:
Heterogeneous queries and use of OLEDB providers are not supported in fiber mode.
pointers, solutions and scripts for the SQL DBA
not intended to replace msdn, common sense or oxford commas
Here's a script I put together to automatically propagate schema changes to keep two SQL Server databases in sync using a DDL trigger. This could just as easily be applied to two databases connected by linked server connections.
This isn't the only solution for schema-only change propagation, I'll have a blog post on that later and update this one when I do.
at 10:37 AM