Viewing 7 posts - 31 through 38 (of 38 total)
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:
[font="Comic Sans MS"]She Through Whom All Data Flows[/font]
May 29, 2009 at 9:42 am
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...
[font="Comic Sans MS"]She Through Whom All Data Flows[/font]
May 19, 2009 at 10:11 am
Is there a time-out period that can be set for a specific view? If so, how do I find it?
[font="Comic Sans MS"]She Through Whom All Data Flows[/font]
May 4, 2009 at 11:28 am
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...
[font="Comic Sans MS"]She Through Whom All Data Flows[/font]
May 4, 2009 at 11:26 am
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...
[font="Comic Sans MS"]She Through Whom All Data Flows[/font]
May 4, 2009 at 10:03 am
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...
[font="Comic Sans MS"]She Through Whom All Data Flows[/font]
April 23, 2009 at 11:21 am
Thanks, just what I was looking for!
[font="Comic Sans MS"]She Through Whom All Data Flows[/font]
April 21, 2009 at 5:40 pm
Viewing 7 posts - 31 through 38 (of 38 total)