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...

Is there a time-out period that can be set for a specific view? If so, how do I find it?

The code for the view is exactly as posted above. The view won't run (times out) but if I just copy the same code to a new query window and...

Yes, I'm just running the view from Management Studio.

Where do I look to see the remote query timeout setting?

I don't understand why the remote query timeout would affect the...

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...

Thanks, just what I was looking for!