Creating Views | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Creating Views

I would like to create a view of a table which is of different database resides in different server. This can be done through link server. How do I create the index for the View

You can’t create an indexed view between servers. The reason is that you need to create the view with schemabinding, which does not allow a four part name Cheers
Thanks Twain <img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />