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 |
|
Peace2007
Posting Yak Master
239 Posts |
 Posted - 2008-08-04 : 03:13:27
|
| I need to gather information from a few linked servers using Distributed Partitioned Views but something makes me worried: if one server, by any reason, fails does the view fail to run? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-04 : 23:34:19
|
| yes. |
 |
|
|
Peace2007
Posting Yak Master
239 Posts |
Posted - 2008-08-05 : 00:54:03
|
| then such views are so unreliable. Isn't there any other way? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Distributed Partitioned Views