NEWBIE: Trying to drop column with many columns failing

Dear Experts,

I'm trying to drag and drop a table into a tabbed pane in Visual Studio 2005 (C#), and I'm getting this message:

     sum of the columns' FillWeight values cannot exceed 65535

Admittedly, the table has around 400 or so columns...

Is there any way around this?

Thanks,
BrianMc1958
BrianMc1958Asked:
Who is Participating?
 
dabitbolCommented:
Hi,

Seriously, I would consider normailizing your database (split into smaller tables), this will be a serious performance issue if you try to query all of your columns. Another way would be to create a view for a subset of your Data. Don't forget, with 400 columns your transferring a huge chunk of data over the internet or network.

Good Luck!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.