I had the same problem and worked around it by wrapping the DML statement in a proc on the remote machine then just calling the proc from the 2005 box.

Thanks to both of you. I really appreciate your help!

Thanks Luke. Just to make sure I understand what you are saying, I could add a column to the table I'm joining using a function, then add a default...