Adding new column to the table with 16 million rows

  • 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?

  • Do you want to add a nullable column or a non-nullable column with a default value? And where you do want to add it? As the last column?

    What does "SELECT @@version" report?

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

  • ...and do you want the new column to replicate or not?

    Igor Micev,
    My blog: www.igormicev.com

  • The table where i need to add a column that is already replicated.

Viewing 4 posts - 1 through 3 (of 3 total)

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