locked
Open table Fails when there are large number of columns in a table RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

    Friday, March 3, 2006 6:40 PM

Answers