Microsoft KB Archive/136531

{|
 * width="100%"|

FIX: SELECT INTO From a ALTERed TABLE Cannot be Performed

 * }

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 : kbprogramming

Issue type : kbbug

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600