Let me try to briefly explain the solution I have. I apologize in advance for the lack of supporting info, but I do not have time to pretty it...

You mentioned that dynamic SQL against remote database is a little quirky. Does that explain why I get one message in the output log and a separate error message...

Thanks for the replies. I think I have solved the problem with solutions similar to those suggested here. I used the sys.servers table, without the Is_Linked logic, to...

I have punted. I have looked around and have given up. I recreated the procedure with a new name and dropped the old procedure. It is all...

The word COLLATE is no where in my procedure and I do not recall seeing it anywhere when building any recent tables or indexes.

Any way to reset the collate for...

Rather than posting a very long Oracle procedure, I will just describe what the Oracle procedure does. First, let me say my solution is derived from an elegant solution...

I believe the columns metadata would be used, but I am not looking for differences in the table structures. I am looking to compare the data in the two...

Great news. Microsoft made it simple to get the procedure name and this forum helped me find the answer within minutes. You guys rock.