Skip to main content

How to add an article in Transactional Replication

If we have a set-up of Transactional Replication for Data Distribution running and wanting to add new object to replication on other server we can follow below process.

To add an article In Transaction replication with PUSH Subscription 
  1. Run Add Article Stored Procedure on Publisher Database (sp_addarticle)
  2. Run Add Subscription Procedure on Publisher Database (sp_addsubscription)
  3. Run Snapshot Agent from REPLMON.


To add an article In Transaction replication with PULL Subscription
  1. Run Add Article Stored Procedure on Publisher Database (sp_addarticle)
  2. Run Refresh Subscription on Publisher Database (sp_refreshsubscriptions)
  3. Run Snapshot Agent from REPLMON.
Labels:

Comments

  1. Anonymous30 August 2014 at 01:13

    I am working hard on the new Warface hack 2014 (Wallhack, Aimbot,
    Unlimited Speeds and Unlimited Credits) and I have been made this for all players.


    These new Warface hack 2014 come with a lot
    of features and include everything from ESP to a full blown aimbot.

    If you have been under a rock or hiding away from
    your PC you need to check out the Warface hack 2014 now and download it by clicking at the bottom.

    This game is going to be one of the most popular free to play first person shooter this year.


    To make your game even more fun all users will get this Warface hack 2014
    for free, you unlock all weapons and win every single round!

    Warface is a free to play 3D military MMOFPS developed by Crytek (best known for developing Far Cry, Crysis and CryENGINE) with next gen visuals.


    Download: http://tinyfileshost.com/download/235964/Y2ODBiY/1

    Mirror: http://filespeedy.net/download/235964/ZjRhN

    My weblog: the best hack for warface

    ReplyDelete
  2. Anonymous3 December 2018 at 08:14

    Spot on with this write-up, I truly believe this
    web site needs much more attention. I'll probably be returning to
    read more, thanks for the information!

    ReplyDelete
  3. Anonymous4 April 2019 at 02:11

    What's Taking place i'm new to this, I stumbled upon this I've found It absolutely useful
    and it has aided me out loads. I am hoping to contribute
    & aid other customers like its aided me. Good job.

    ReplyDelete
  4. Anonymous10 April 2019 at 19:10

    I simply could not leave your site before suggesting that I actually enjoyed the standard information an individual provide for your guests?
    Is gonna be back regularly to inspect new posts

    ReplyDelete
  5. Anonymous11 April 2019 at 14:36

    Your style is unique in comparison to other people I've read
    stuff from. Thank you for posting when you've got the opportunity, Guess
    I'll just bookmark this web site.

    ReplyDelete
  6. Anonymous14 April 2019 at 06:37

    Way cool! Some extremely valid points! I appreciate you penning this article and also the rest of
    the site is also really good.

    ReplyDelete
  7. Anonymous16 April 2019 at 09:17

    Pretty nice post. I just stumbled upon your blog and wished to say that I've truly enjoyed browsing your blog
    posts. After all I will be subscribing to your feed and I hope you write again soon!

    ReplyDelete
  8. Anonymous17 April 2019 at 11:14

    Greetings, I think your site might be having internet browser compatibility issues.
    When I take a look at your website in Safari, it
    looks fine however, when opening in Internet Explorer, it's got some overlapping issues.

    I simply wanted to provide you with a quick heads up! Besides that, wonderful
    website!

    ReplyDelete
  9. Anonymous19 April 2019 at 15:36

    An impressive share! I've just forwarded this onto
    a friend who had been doing a little homework
    on this. And he actually ordered me dinner due to the fact that I discovered it for him...
    lol. So allow me to reword this.... Thank
    YOU for the meal!! But yeah, thanx for spending the time to
    talk about this issue here on your internet site.

    ReplyDelete
  10. Anonymous20 April 2019 at 22:13

    Howdy just wanted to give you a quick heads up. The text in your post seem
    to be running off the screen in Firefox. I'm not sure if this is a
    format issue or something to do with browser compatibility but I
    thought I'd post to let you know. The layout look great though!
    Hope you get the issue resolved soon. Many thanks

    ReplyDelete
  11. Anonymous22 April 2019 at 14:14

    What's up, its good paragraph regarding media print, we all be aware of media is a wonderful source of information.

    ReplyDelete
  12. Anonymous24 April 2019 at 01:36

    Every weekend i used to go to see this website, for the reason that i wish
    for enjoyment, for the reason that this this site conations actually nice funny
    stuff too.

    ReplyDelete
  13. Anonymous23 May 2019 at 09:54

    I couldn't resist commenting. Exceptionally well written!

    ReplyDelete
  14. Anonymous24 May 2019 at 00:48

    Write more, thats all I have to say. Literally, it seems as
    though you relied on the video to make your point.
    You definitely know what youre talking about, why throw away your
    intelligence on just posting videos to your site when you could be giving us something
    enlightening to read?

    ReplyDelete
  15. Anonymous26 July 2019 at 11:16

    Komen die nieuwe hoesjes ook nog in IPhone X? Zou ze namelijk heel
    graag willen @LinkTijger

    ReplyDelete
  16. Anonymous26 July 2019 at 15:55

    Different covers include different options relying on the sort of material that's used in the
    manufacture of the case. Second, is the hurt enough that it justifies the
    economics of taking on the case. It was simply half a meter
    large, which allowed greater than enough area for a human being to
    go by means of. You'll be able to read extra concerning
    the movie, on Wikipedia or IMDB. Nowadays the young
    individuals seems desire those personalised things, that's why
    I also buy a customized case printer which may print customized image on the case.
    Below picture shows the "before and after" picture of iPhone 6 plus with custom stickers.
    Its an awesome television nice picture i would really like to fix it.
    After eradicating a number of extra odd particleboard items, all that was left is a chunk that appears like a cabinet or desk on wheels.
    The shoppers particularly the younger individuals wish to make their
    customized, that is why I can promote about a hundred orders of
    customized cellular phone skins per day thought my online shop.

    Firstly I by no means consider promote one hundred stickers
    in any respect; nevertheless the customers are actually
    fascinated by such a brand new item.

    ReplyDelete
  17. Anonymous26 July 2019 at 21:21

    Afgelopen week hebben we te horen gekregen dat de iPhone 8 en iPhone X zeer gauw uit gaat
    komen. Zeker nu de feestdagen steeds dichterbij komen.

    ReplyDelete
  18. Anonymous27 July 2019 at 21:22

    @MelisaSuAkar üzerinde yastıklı kılıf da yapsınlar artık markaları
    bıraksınlar. Uykumuz gelince atar yere uyuruz bence.

    ReplyDelete
  19. Anonymous2 August 2019 at 20:20

    Haq haq haq.......murder is the case.

    ReplyDelete
  20. Anonymous5 August 2019 at 11:05

    Motions is likely to be instituted and this may help the case of the
    accused in no small means. Costs of such a service can differ in an enormous means.

    ReplyDelete
  21. Anonymous30 September 2019 at 14:33

    Чтобы получать прибыль и иметь
    посещаемость на сайтах - нужно
    заказывать продвижение сайта.

    Выбирать исполнителя нужно тщательно и лучше опираться на его
    позиции и его портфолио.

    Заказать комплексное продвижение сайта просто - а
    получить результат сложно.

    Выбрав исполнителями нас, вы получаете профессиональные услуги по продвижению сайта.

    ReplyDelete
  22. Anonymous7 October 2019 at 03:43

    Чтобы получать прибыль и иметь посещаемость на сайтах - нужно заказывать продвижение сайта.

    Выбирать исполнителя нужно тщательно и
    лучше опираться на его позиции
    и его портфолио.
    Заказать комплексное продвижение сайта просто - а получить результат сложно.

    Выбрав исполнителями нас,
    вы получаете профессиональные услуги по продвижению сайта.

    ReplyDelete
  23. Anonymous8 October 2019 at 14:21

    Чтобы получать прибыль и иметь посещаемость на сайтах - нужно
    заказывать продвижение сайта.
    Выбирать исполнителя нужно тщательно и лучше опираться на его позиции и его портфолио.


    Заказать комплексное продвижение сайта просто - а получить
    результат сложно.
    Выбрав исполнителями нас, вы получаете профессиональные услуги по продвижению
    сайта.

    ReplyDelete
  24. Anonymous8 October 2019 at 20:31

    Чтобы получать прибыль и иметь
    посещаемость на сайтах - нужно заказывать продвижение сайта.

    Выбирать исполнителя нужно тщательно
    и лучше опираться на его позиции и его портфолио.


    Заказать комплексное продвижение сайта просто
    - а получить результат сложно.


    Выбрав исполнителями нас, вы получаете профессиональные услуги по продвижению сайта.

    ReplyDelete
  25. Anonymous24 October 2019 at 19:57

    Right here is the right blog for anybody who wants to understand this topic.
    You understand a whole lot its almost hard to argue with you (not that I actually would want to…HaHa).
    You definitely put a fresh spin on a topic which has been discussed for years.

    Excellent stuff, just wonderful!

    ReplyDelete
  26. Anonymous24 October 2019 at 21:07

    No matter if some one searches for his required thing, so he/she wishes to be available that in detail,
    therefore that thing is maintained over here.

    ReplyDelete
  27. Anonymous25 October 2019 at 03:07

    I think that everything wrote made a great deal of sense. However, what about this?
    what if you wrote a catchier post title? I mean, I don't
    wish to tell you how to run your website, however what if you added
    a post title to possibly grab folk's attention? I mean "How to add an article in Transactional Replication" is kinda boring.
    You ought to peek at Yahoo's front page and note how they write news
    headlines to grab viewers interested. You might add a related video
    or a pic or two to grab people excited about everything've written.
    In my opinion, it could make your posts a little livelier.

    ReplyDelete
  28. Anonymous15 November 2019 at 11:51

    Hi! This is my first comment here so I just wanted to give
    a quick shout out and tell you I really enjoy reading your articles.
    Can you suggest any other blogs/websites/forums that go over the same subjects?
    Thank you so much!

    ReplyDelete
  29. Ratnavali Arts : Best Jewellery Wholesaler in Jaipur, Jewellery shop in Jaipur8 September 2021 at 07:24

    Wao it's a great blog, Thank You! for sharing this information.
    Ratnavali Arts ( Best Jewellery Wholesaler in Jaipur, Jewellery shop in Jaipur )
    https://www.ratnavaliarts.com/
    Jaipur jewellery wholesale online, jewellery wholesaler in jaipur

    ReplyDelete

Post a Comment

Plz dont forget to like Facebook Page..
https://www.facebook.com/pages/Sql-DBAcoin/523110684456757

Popular posts from this blog

History of MySQL from AB Corp to Cloud Database

MySQL was created by a Swedish company, MySQL AB, founded by David Axmark, Allan Larsson and Michael "Monty" Widenius. Original development of MySQL by Widenius and Axmark began in 1994. The first version of MySQL appeared on 23 May 1995. Its name is a combination of "My", the name of co-founder Michael Widenius's daughter,and "SQL", the abbreviation for Structured Query Language. ·          23 May 1995 - First internal release ·          Year 1996 - Version 3 o     Simple CRUD operations o     January 1997 Windows version was released on 8 January 1998 for Windows 95 and NT o     production release 1998, from www.mysql.com ·          Year 2002 - Version 4 o     MyISAM o     unions o     Tracking o     B-trees o     s...
34 comments
Read more

How to encrypt and decrypt Table data in postgres

For encrypting and decrypting , we must use the bytea data type on the column which we implement. Bcoz bytea will use the pgcrypto method by default. However, you will need to create the pgcrypto extension to enable these functions as they are not pre-defined in PostgreSQL/PPAS. Example CREATE EXTENSION pgcrypto; CREATE TABLE userinfo (username varchar(20), password bytea); >>    Inserting the data in an encrypted format INSERT INTO userinfo VALUES(' suman ',encrypt('111222','password','aes')); select * from userinfo ; >>    Retrieving the data as decrypted format SELECT decrypt(password,decode('password','escape'::text),'aes'::text) FROM userinfo; Thanks for reading Plz dont forget to like Facebook Page.. https://www.facebook.com/pages/Sql-DBAcoin/523110684456757
1 comment
Read more

How to recover msdb database from suspect mode

 It was Monday 9 th Jun 47 degr. temperature of Delhi-NCR. Temperature was like boiling me and database. When I reached my office( @ 8.45 am) got an alert from one of Server. “MSDB is in suspected mode” At the same time comes in my mind, this issue will boil me today.. I just tried to cool my self through cold drink then connected server from my local system using windows authentication mode..
5 comments
Read more