HI, When i create the replication to replicate a indexed view, i notice that it says " indexed view articles are supported only in enterprise edition of sql server 2000 or later". Do anyone know what does it mean?  Is it mean that enterprise edition is required for replicating indexed views as tables? I dont know whether i could use standard edition of sql server 2012/2008 to replicate indexed view as tables. Thanks!

• Edited by never-forgot Friday, February 14, 2014 3:54 AM

You can replicate an indexed view no problem in SQL server 2000 and above. Indexed views were introduced in SQL 2000 which is why Microsoft makes that statement. The query engine will only consider using an indexed view in an execution plan in the Enterprise Edition, but it can be used in the Standard Edition with hints.

It does not matter what edition you are replicating to or from to replicate the indexed view to a table.

Hi never-forgot,

According to your description, as other post, in SQL Server 2000, Indexed Views is introduced as an Enterprise Edition feature. And now you could create Indexed Views in all editions of SQL Server 2005 or later.

In all verisons of SQL Server 2008/2012, you can replicate Indexed Views as table (Transactional Replication or Merge Replication). To replicate an indexed view as a table, you need to note modifying the @type parameter of the sp_addarticle system procedure. By default, this parameter has a value of Nindexed view schema only for indexed views; you need the value of Nindexed view logbased for an existing publication to replicate as a table.

There is a similar issue about replicate Indexed Views as table via T-SQL/GUI, you can review the following article.
http://sqlship.wordpress.com/2010/04/14/replicate-indexed-views-transactional-replication/

http://www.informit.com/articles/article.aspx?p=607372&seqNum=3

Have a look at the link http://msdn.microsoft.com/en-us/library/ms152559.aspx.  This explains all the objects that can be replicated for SQL Server 2008/2012.

Regards,
Sofiya Li