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

ID: Q238481

The information in this article applies to:

Microsoft SQL Server version 7.0

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 version 7.0.

Additional query words:

Keywords : SSrvAdmin SSrvEntMan SSrvSQL_Admin kbbug7.00 kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug