Post reply

table from replication??

  • December 21, 2006 at 7:55 am

    #90867

    hi

    i have database A and database B

    B is subscribed to a replication from A

    i have a table on B.

    i need to know if this table come from one of the published articles of the replication from A or it doesnt .

    by few words i need to know if this table is a replicated one or no.

    i need it in a script form.

    any help plz.

    If something's hard to do, then it's not worth doing.

  • December 22, 2006 at 1:14 am

    #679661

    Hi

    You will need to check the distibution database

    use distibution

    go

    select * from msarticles where article =''

    Thanks

  • December 26, 2006 at 1:09 am

    #679942

    ok man thanks a lot.

    If something's hard to do, then it's not worth doing.

  • December 26, 2006 at 1:16 am

    #679943

    If you don't have permission to see distribution database, see triggers of that table for Database B, if there are three triggers (insert, update and delete) it may looks like

    ins_E583CD913A23410E90E567CF5E0BC371

    del_E583CD913A23410E90E567CF5E0BC371

    upd_E583CD913A23410E90E567CF5E0BC371

    if found it is participating in replication, otherwise it won't have any trigger like these above names.

     

    Shamshad Ali.

  • December 26, 2006 at 1:26 am

    #679944

    i didnt find those triggers even i checked the some tables on database B that i know its participating in a replication and i  didint find them.

    :S

     

     

    If something's hard to do, then it's not worth doing.

  • December 26, 2006 at 6:30 am

    #679957

    If there is no such trigger on tables, how your replication is working? without Triggers I never saw database that replicates somewhere. Due you realize it or not?

    Shamshad Ali.

  • December 26, 2006 at 6:43 am

    #679958

    well no triggers and replication is working fine!!!

    If something's hard to do, then it's not worth doing.

  • December 26, 2006 at 12:49 pm

    #680008

    You guys are talking different types of replication...

    I think Shamshad is refferring to merge replication and Charbel is transactional...

    I think Merge replication uses these types of triggers..

    MohammedU
    Microsoft SQL Server MVP

  • December 26, 2006 at 11:11 pm

    #680041

    yes its a transactional replication !

    If something's hard to do, then it's not worth doing.

  • December 28, 2006 at 11:54 am

    #680337

    It is always better to specify complete details when posting so that people can answer better...

    MohammedU
    Microsoft SQL Server MVP

  • December 28, 2006 at 11:21 pm

    #680453

    ye right hehe!!

    If something's hard to do, then it's not worth doing.

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply