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 |
|
cidr
Posting Yak Master
207 Posts |
 Posted - 2010-02-25 : 11:35:16
|
| Hi, is it possible to replicate an indexed view as a table on another server with SQL server 2000?If so, is it possible for the indexed view to have underlying (non-indexed) views in its query and have transactional replication or near to real time?Thanks for any help! |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-02-25 : 14:48:34
|
yes. indexed views can be replicated no problem.Easy enough to test it out...  |
 |
|
|
cidr
Posting Yak Master
207 Posts |
Posted - 2010-02-26 : 04:09:17
|
| Thanks for the reply Russall. I've checked this and unfortunately it doesn't seem possible to have the indexed view reference other views. It will fail.Don't know if there's a way round this!?Thanks |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-02-26 : 10:48:23
|
| If an indexed view references a view, that view must also be schema bound |
|
|
|
|
|
|
Replicating Indexed view to table