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


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
  • Microsoft SQL Server 7.0
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.
Modification Type:MajorLast Reviewed:10/17/2003
Keywords:kbbug kbpending KB281347
©2003 Microsoft Corporation. All rights reserved.