BUG: Enterprise Manager: Error Message "Too many columns defined in the rowset" (238481)
The information in this article applies to:
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.
| Modification Type: | Major | Last Reviewed: | 10/16/2002 |
|---|
| Keywords: | kbBug KB238481 |
|---|
|