FIX: SELECT INTO From a ALTERed TABLE Cannot be Performed

• Microsoft SQL Server version 6.0

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        : 

Last Reviewed: April 20, 1999