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

SQL Server - Adding a transactional pull subscriptions to a publication in replication

Oct 21 2011 1:53AM by Paresh Prajapati   

You may read earlier post to add transactional publication in replication here http://beyondrelational.com/justlearned/posts/730/adding-the-transactional-publication-in-replication-sql-server.aspx, here how can we add a transactional pull subscriptions to a publication which executed in publisher database.

USE [PublisherDB]
GO
EXEC sp_addsubscription 
    @publication = N'Publication Name', 
    @subscriber = N'Subscriber Server', 
    @destination_db = N'Subscription database', 
    @subscription_type = N'Pull', 
    @sync_type = N'automatic', 
    @Article = N'all', 
    @update_mode = N'read only',
    @subscriber_type = 0
GO
Read More..  [0 clicks]


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



Submit

Your Comment


Sign Up or Login to post a comment.

"SQL Server - Adding a transactional pull subscriptions to a publication in replication " rated 5 out of 5 by 4 readers
SQL Server - Adding a transactional pull subscriptions to a publication in replication , 5.0 out of 5 based on 4 ratings
    Copyright © Beyondrelational.com Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising