Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
thienqnguyen
Starting Member
1 Post |
 Posted - 2009-01-15 : 19:46:08
|
| I have a very interesting problem with linked servers in a distributed view and would love your inputs.Let's say that there are 3 servers participating in a view on primary server A, with servers all SQL2005 sp2. If the view contains databases with the following combinations, the queries are returning without problem:- A and B- B and C- CBut if the view contains A+C or A+B+C, the query takes 10 minutes to return. It seems the combination of A+C is running the problem.Thanks for your inputs. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-15 : 19:50:56
|
| Your question is not clear. |
 |
|
|
|
|
|
Slow linked server