FIX: SELECT INTO From a ALTERed TABLE Cannot be Performed |
Q136531
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.
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.
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
|
Last Reviewed: March 28, 2000 © 2001 Microsoft Corporation. All rights reserved. Terms of Use. |