Hidden max number of columns in Management Studio?

17 Mar 2006 6:43 PM

Kan

Hi,

The following is observed in the SQLServer 2005 Management Studio Visual
Editor:

Open table (Right Click option on a table) fails when I try it on a table
with lots of columns in it > 820 columns! Currently the table has no rows
(empty table). The same table opens fine with sql 2000 enterprise manager.
This table has been migrated/imported from sql 2000 without any errors! Other
imported tables with less number of columns can be opened in the visual
editor!

Wondering is there a hidden limit in terms of number of columns with
SQLserver 2005 Management Studio (Grid) Visual Editor?

I get SQL Executaion error

Error Source: Microsoft.VisualStudio.DataTools

Exception has been thrown by the target of an invocation

Is this a known behavior/limitation/bug? Is there a workaround?

Thanks

18 Mar 2006 4:00 AM

Steve Kass

Kan,

See
http://www.sql-server-performance.com//forum/topic.asp?TOPIC_ID=9016&#40300

You may wish to report this as a bug at the suggested URL
http://lab.msdn.microsoft.com/productfeedback/default.aspx
(also in the thread).

Steve Kass
Drew University

Kan wrote:

Show quoteHide quote

>Hi,
>
>The following is observed in the SQLServer 2005 Management Studio Visual
>Editor:
>
>Open table (Right Click option on a table) fails when I try it on a table
>with lots of columns in it > 820 columns! Currently the table has no rows
>(empty table). The same table opens fine with sql 2000 enterprise manager.
>This table has been migrated/imported from sql 2000 without any errors! Other
>imported tables with less number of columns can be opened in the visual
>editor!
>
>Wondering is there a hidden limit in terms of number of columns with
>SQLserver 2005 Management Studio (Grid) Visual Editor?
>
>I get SQL Executaion error
>
>Error Source: Microsoft.VisualStudio.DataTools
>
>Exception has been thrown by the target of an invocation
>
>Is this a known behavior/limitation/bug? Is there a workaround?
>
>Thanks
>
>
>