How to overcome on views limits

[wizard10]

Hi Everyone,

I have 6 tables with many many columns and I have a SELECT statement that joins all the table and brings me all the columns in each table in single view. The number of columns that I get by executing this SELECT statement are more than 2000. The SELECT statement runs perfect and give me no problem. But the problem comes when I use this select statement in a view. I get the error message

CREATE VIEW failed because column '' in view '' exceeds the maximum of 1024 columns

Is there a way I can get all the columns in one single view. I know SQL Server View has maximum limit of 1024 colums.

Please help if someone has a better idea.

I will appreciate your help in this regard

Thanks.

 

[alfalf]

Run MySQL Administrator (you can find it on mysql web), Choose StartUp Variables -> MyISAM Parameters (Tab) -> Advanced Settings Block -> Increase Block Size. This should do it.