Hidden max number of columns in Management Studio?

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
Kan,
See
http://www.sql-server-performance.co...ID=9016鵬
You may wish to report this as a bug at the suggested URL
http://lab.msdn.microsoft.com/produc...k/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
>
>

HELP? Space available: 0MB when ...

displaying the property of a database? What does it mean?

I am sure when this happens but now when I right click on a database and
select property, the space available= 0.00MB.

I still have physical space on the server.

When viewing the taskpad.

Space allocated:

data 5500MB used, 1700 MB free
log 15MB used, 300 MB free

Please help. Thank youif i remember something i read correctly, the database files are set to a certain size upon creation. any space that isn't used by working data is filled up with empty pages.

If the database isn't storing any more data, then it must be full. In this case you would need to set it to automatically grow when it gets full.|||I forgot to add that the data file and log file are set to automatically
growth by 10%.

Any other thoughts. Thanks|||For a database that size, I would set it to a flat growth rate (say 10 or 50MB, depending on how fast it grows). As for Enterprise Manager. I have not trusted the numbers it generates for a long time. I would not worry too much over it.