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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 use indexed views insted of tables to sync

Author  Topic 

Sun Foster
Aged Yak Warrior

515 Posts

Posted - 2006-02-14 : 09:32:54
Our company use Red-Gate sync program to sync tables between remote and local server. There are two tables in remote server without primary key and Red-gate supportor recommend me to use INDEXED VIEWS.
Can someone show me how to do it?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-02-14 : 13:20:33
I don't understand why it says to use indexed views. What are you trying to do?

Have you read about them in SQL Server Books Online?

Tara Kizer
aka tduggan
Go to Top of Page
   

- Advertisement -