Microsoft KB Archive/813448

= PRB: Row Size May Increase After the Datatype of a Column Is Altered =

Article ID: 813448

Article Last Modified on 4/12/2004

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



Bug #: 363637 (SQL Server 8.0)



SYMPTOMS
When 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(< >)



WORKAROUND
If 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.

Keywords: kbbug KB813448

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.