Home > Archive > MS SQL Server Tools > March 2006 > Hidden max number of columns in Management Studio?









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Hidden max number of columns in Management Studio?
Kan

2006-03-17, 1:23 pm

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

Steve Kass

2006-03-18, 3:26 am

Kan,

See
http://www.sql-server-performance.c..._ID=9016鵬

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

Steve Kass
Drew University

Kan wrote:

>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
>
>
>

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com