Home Forums SQL Server 2008 SQL Server 2008 Administration is there any downtime required for adding new column for a large table..and adding a newe table RE: is there any downtime required for adding new column for a large table..and adding a newe table

  • September 2, 2014 at 3:52 am

    #1742349

    I think the large table will be locked while the new column is added. Try it for yourself on a test server, and see what locks are acquired. Adding a new table won't affect anything.

    John