Adding new column to the table with 16 million rows RRS feed

  • Question

  • we have a table with 16 Million records,

    and also this table is replicated.

    we want to add a new column in to this table for some reason?

    what can harm?


    Thursday, July 11, 2013 8:43 PM


All replies

  • What database? Otherwise not much concern aside from your standard concerns: backup, restore points, user downtime...

    Hope this is Helpfull. J Alverson Microsoft BI Solutions Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    Friday, July 12, 2013 12:13 AM
  • If the table is replicated, then adding a new column would send 16 million transactions to the distributer if it is Transaction replication.

    What is the replication method used?

    Friday, July 12, 2013 2:15 AM
  • transactional


    • Marked as answer by '''HuuM''' Wednesday, July 17, 2013 1:47 PM
    Friday, July 12, 2013 5:37 AM