Microsoft KB Archive/281347

= BUG: Can't Append Columns to Tables with Large Number of Columns in SEM Table Designer =

Article ID: 281347

Article Last Modified on 10/17/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q281347



BUG #:100851 (SQLBUG_70)

Bug #:350961 (Shiloh_Bugs)



SYMPTOMS
The table designer in Enterprise Manager does not provide a blank row to append a column to an existing table when that table has more than 299 columns. However, the designer does allow insertion of columns prior to the last column of the table.



WORKAROUND
Use the ALTER TABLE statement to append new columns to the table.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: add column enterprise manager SEM DaVinci

Keywords: kbbug kbpending KB281347

-

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

© Microsoft Corporation. All rights reserved.