Is it possible to replicate Store Procedure ?

Discussion in 'microsoft.public.sqlserver.replication' started by Kail, Oct 26, 2004.

  1. Kail

    Kail Guest

    Is it possible to replicate Store Procedure ?

    Because I cannot found the article for is, does anyone try it before?

    --
     
    Kail, Oct 26, 2004
    #1
    1. Advertisements

  2. Kail

    Paul Ibison Guest

    Kail,
    stored procedures can be replicated as any other article.
    The things to remember are that we can't replicate system
    tables, so the text of the stored proc (syscomments)
    won't be replicated in the same way as normal user data.
    This means that if the procedure changes, it won't be
    picked up by the replication process. As they are treated
    in a different way, and a new snapshot might be needed on
    a regular basis, you might want to place the stored procs
    in a separate publication. This is how I set things up,
    with a post-snapshot script to be run which adds the
    permissions.
    Another aspect of replicating stored procedures is that
    transactional replication will give you the option to
    replicate the EXECUTION of the stored procedure as well
    as the procedure itself.
    HTH,
    Paul Ibison SQL Server MVP, www.replicationanswers.com

    (recommended sql server 2000 replication book:
    http://www.nwsu.com/0974973602p.html)
     
    Paul Ibison, Oct 26, 2004
    #2
    1. Advertisements

  3. Kail

    Kail Guest

    Dear Paul

    Thanks for your help

    kail
     
    Kail, Oct 27, 2004
    #3
  4. Kail

    nelson david Guest

    nelson david, Jul 4, 2010
    #4
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.