Thanks ever so much! I don't have permissions to add a linked server, so am forwarding this info on to my IT department. And trying to maintain my optimism.:hehe:
These are both in the same db, linked to sql server 2005. For now I have solved the problem by unchecking the "use trusted connection" from the problem query, and...
Thanks for the replies. William and Jim, it seems like your solutions are basically equivalent to what I'm alread doing, so I guess I'll just keep it as is. Seems...