Viewing 3 posts - 1 through 3 (of 3 total)
Found it. The server properties, Connections tab specifies a remote query timeout. This value can be overridden on the linked server properties Server Options tab.
Don't ya just love it when...
December 14, 2004 at 10:35 am
Update:
When I said 'When I run the remote procedure manually from the Query Analyzer,' I was connected to the secondary. When I tried remote execution while connected to the primary, I...
December 14, 2004 at 9:36 am
OK, here's some results:
The 'select * from master..systemprocesses' shows some blocked processes with wait times in the few-seconds range, which indicates (according to Douglas) many small transactions. I am inclined...
October 6, 2004 at 11:03 am
Viewing 3 posts - 1 through 3 (of 3 total)