Getting Started with Web applications development with servlets and JSP - Part 5: Filters
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.


Upload Image Close it
Select File

Learned something today? Share it, or learn from what others have learned today

Adding Indexed views in publication for transactional replication - SQL Server

Oct 16 2011 12:19AM by Paresh Prajapati   

We can add indexed views in transactional publication same as normal views (http://beyondrelational.com/justlearned/posts/701/.aspx) for transactional replication.

USE PublisherDB
GO
EXEC sp_addarticle 
    @publication = N'PublicationName', 
    @article = N'Indexed View Name', 
    @source_owner = N'SchemaName', 
    @source_object = N'Indexed View Name', 
    @type = N'indexed view schema only', 
    @description = N'', 
    @creation_script = N'', 
    @pre_creation_cmd = N'drop', 
    @schema_option = 0x0000000008000001, 
    @destination_table = N'Indexed View Name', 
    @destination_owner = N'SchemaName', 
    @status = 16
GO
Read More..  [7 clicks]


Paresh Prajapati
7 · 24% · 5511
2
 
1
 
 
0
Incorrect
 
0
Interesting
 
0
Forgotten
 
0
Move



Submit

Your Comment


Sign Up or Login to post a comment.

"Adding Indexed views in publication for transactional replication - SQL Server" rated 5 out of 5 by 2 readers
Adding Indexed views in publication for transactional replication - SQL Server , 5.0 out of 5 based on 2 ratings
    Copyright © Beyondrelational.com Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising