Microsoft KB Archive/238481

= BUG: Enterprise Manager: Error Message "Too many columns defined in the rowset" =

Article ID: 238481

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q238481



BUG #: 51112(SQLBUG_70)



SYMPTOMS
When using Enterprise Manager if you right-click on a table that has more than 255 columns and you select 'Return All', the following error message appears:

Too many columns defined in the rowset.

SQL Server 7.0 allows for tables of up to 1024 columns.



CAUSE
This is a limitation of the interfaces that Enterprise Manager uses to view the output of the 'return all' feature.



WORKAROUND
You must run 'select * from table_name' using the Query Analyzer to view all rows in table.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.

Keywords: kbbug kbpending KB238481

-

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

© Microsoft Corporation. All rights reserved.