Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Big KL Hutch
Starting Member
3 Posts |
 Posted - 2006-12-12 : 12:16:55
|
| I have a LIVE SQL 2000 database. I am trying to add some new columns to a table. My question is will I need to take the database off-line to perform this operation? I have replicated it to a sample table if I can't.KL Hutch |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2006-12-12 : 12:58:38
|
| You can alter a table without taking the database off-line. However if the table is being replicated, I don't believe you will be able to alter it. Any operations that use the table will be blocked during the alter. If your new columns include default values or identity or referencial integrety checks then the table will be blocked for the time it takes to perform those operations as well.Be One with the OptimizerTG |
 |
|
|
|
|
|
Adding Columns to a Table