CODEWITHSUNDEEP
sqlvisual-studio-2008sap-erp
Perfection
Perfection

Reputation: 721

The results viewer cannot execute a query with more than 655 columns in the project list

I am using Visual Studio 2008's server explorer and I need to search through a database for invoice lines. So I find this one table named ixvFact but when I try to retrieve the results, visual studio gives me the following error and does not show me the results.

The results viewer cannot execute a query with more than 655 columns in the project list.

What does this mean? How can I solve this?

Upvotes: 2

Views: 1515

Answers (1)

Hituptony
Hituptony

Reputation: 2860

you can specify the columns you want to retrieve instead of selecting all columns from the table...I thought there was a limit on the number of columns in a table...that's very bad practices...

Upvotes: 2

Related Questions