PRB: Row Size May Increase After the Datatype of a Column Is Altered (813448)
The information in this article applies to:
- Microsoft SQL Server 2000 (all editions)
Bug #: 363637 (SQL Server 8.0) SYMPTOMSWhen the datatype of a column is altered, such as changing a
char(100) value to a varchar(100) value, the minimum and maximum row size will
increase by approximately 100 bytes, causing the table to use more space than
expected.
You can determine the row size by using DBCC
SHOWCONTIG(<tablename>) WORKAROUNDIf the table does not have NOT NULL columns after the
altered column, you can rebuild the clustered index on the table to reclaim the
additional space. Otherwise, the only way to reclaim the space is to rebuild
the table. You can drop and re-create the table, or you can use SELECT INTO to
copy the data into a new table.
| Modification Type: | Major | Last Reviewed: | 4/12/2004 |
|---|
| Keywords: | kbBug KB813448 kbAudDeveloper |
|---|
|