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