Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2005
    Posts
    2

    Unanswered: Replication Question

    I have continuous transactional replication running from a production server to a reporting server. Both servers are SQL 2000. A week or so ago, a new column was added to a table being replicated, both production and reporting servers. I need to get that field included in the replication. Can this be done without having to drop the subscription, adding the field, re-create the subscription and then re-creating a snapshot?

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Go to BOL. Look up sp_repladdcolumn. Here is part of what it says:


    sp_repladdcolumn
    Adds a column to an existing table article that has been published. Allows the new column to be added to all publishers that publish this table, or just add the column to a specific publication that publishes the table. This stored procedure is executed at the Publisher on the publication database.

    -- This is all just a Figment of my Imagination --

  3. #3
    Join Date
    Aug 2005
    Posts
    2
    Thank you!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •