Try this thread,
But, its always good to have all the servers running with same collation.
you may find the book, [Dissecting SQL Server Execution Plans] by Grant Fritchey...
Hi,Please try this and let me know if it helps.
SELECT *FROM (SELECT M.*, C.ChildID, C.DateStamp, C.Description FROM MasterTable MINNER JOIN...
Separate names with a comma.