Post reply

Adding new column to the table with 16 million rows

  • July 11, 2013 at 3:05 pm

    #275085

    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?

  • July 11, 2013 at 4:09 pm

    #1631767

    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]

  • July 12, 2013 at 5:59 am

    #1631897

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

    Igor Micev,My blog: www.igormicev.com

  • July 12, 2013 at 8:15 am

    #1631975

    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