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.
Friday, February 18, 2011
Monday, February 14, 2011
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.