FIX: SELECT INTO From a ALTERed TABLE Cannot be Performed

ID: Q136531

The information in this article applies to:

Microsoft SQL Server version 6.0

BUG# NT: 10972 (6.00)

SYMPTOMS

On Microsoft SQL Server version 6.0, you can not perform a SELECT INTO from a table that has been ALTERed to add an IDENTITY column.

A SELECT INTO will fail with the following error message:

Msg 511, Level 16, State 2
Updated or inserted row is bigger than maximum size (10 bytes)
allowed for this table.

WORKAROUND

Instead of performing an ALTER TABLE to add the IDENTITY column, CREATE a TABLE with the identity column and then transfer the data to the new table with an INSERT operation.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server version 6.0. For more information, contact your primary support provider.

Additional query words: sql6 tsql

Keywords : kbprg SSrvProg SSrvTran_SQL kbbug6.00 kbfix6.00.sp3
Version : 6.0
Platform : WINDOWS
Issue type :