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 - 2002-02-25 : 09:06:23
|
| Reungyos writes "Dear Community,SQL Server version 7.0OS Windows NT 4.0 with lastest service packIn my database we've on table which contain five ntext fields when i checking the size of the table it take 8 M for storage. I think it size is not acceptable. Because when i've try to create another database and dump that table to other database it size is only 2 M. I've try to shrinking the DB but it useless the size of table is not reduce. So if you have any suggestion for me please let me know.Thank in advance,Reungyos" |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-02-25 : 10:00:12
|
| SQL7 had a bug that prevented it from reclaiming the space for text/ntext/image tables. The bug was fixed in SP3, but the fix doesn't take effect unless you restrict the growth of the filegroup where your text fields reside. So the easiest workaround to reclaim the wasted space is to BCP the data out, truncate the table and BCP back in. |
 |
|
|
|
|
|
Problem With size of table which contain 5 ntext fields