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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-02-07 : 09:24:09
|
| alan writes "HiI'm running presonnal addition on my computer and using it as a test server for my web site. The problem is I have a large table with over 20,000 records in it. I would like to add a field into this table, but sql will have none of it and it doesn't respond.I have made a copy (and a backup just in case) and deleted all the records (5000 at a time because it crashed my computer when i tried deleteing them all) and then i was able to add the new field.Please tell me there is a better way, i'm cringing when i think of doing this to the live site.what is going on?Thanks whoeverbazzI now have to put all the records back into" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-02-07 : 09:38:52
|
quote:
Please tell me there is a better way
A better way than what? How are you doing it now? Give us the CREATE TABLE statement for the table as it stands and the ALTER TABLE statement you are using to add the column (not field) ...Jay White{0} |
 |
|
|
srf
Starting Member
42 Posts |
Posted - 2003-02-09 : 23:58:53
|
| I've always used alter table, which is great for people that know TSQL. For the Enterprise Manager issues, I would check for blocking. Also it sounds like your data and/or log files might not be large enough. Deletes can take huge amounts of log space (9 times or more space than the data you're deleting). If your computer or SQL is actually crashing I would contact PSS... that table is very small for SQL Server, and this is a relatively simple task. |
|
|
|
bazz
Starting Member
26 Posts |
Posted - 2003-02-10 : 07:25:21
|
| Yeah i thought so too.I think it is the full-text indexing that is making it crash.Could you see this as being the problem when you want to add another field to the table?thanks againbazz |
|
|
|
|
|
|
Adding a new field