MSDE Text datatype - unable to store more than 900 characters. (msde + visual studio 2003)

Hello,
I'm not sure if it's the setup I did wrong, but I can't seem to get mytext datatype in my database to store more than 900 characters. I'm trying to setup a news database for my website, which will populatethe information into a datagrid. To test, I manually added a newsitem in the database through the visual studio 2003 gui. Iimmediately noticed a problem as the I was getting an error after along news item saying:
"The value you entered is not consistent with the data type or length of the column, or over grid buffer limit."
I couldn't find anthing to set the buffer limit and the datatype is"text" filled with simple text in the column. As a further test,Isimply entered 12334567890123... up to 900 characters and stillrecevied the error.
I would appreciate someone leading me in the right direction on this one.
Thanks a lot.
I think may be your create table statement was not executed correctly because text can grow it is not table space based SQL Server creates an Arithmetic pointer to the file. Try the link below see if you can download the eval edition of the SQL Server. Or you could drop the table and recreate it and test again. Hope this helps.
http://www.microsoft.com/sql/evaluation/trial/default.mspx

MSDE Issue

Hi,
I have a strange issue. We have a DataTable in MSDE with
800 columns. The column name strings are very long.. about
200 characters or more.
When we try to do BULK INSERT into this table, MSDE
results in a General Network error.
We use SQLDataAdapter.
I am working against a very extreme scenario.
Any help?
Regards
Sundari.
It is impossible to have column in a table with its name being longer than
128 characters. SQL Server/MSDE does not allow column name longer than 128
characters.
"Sundari" <sundari_t@.hotmail.com> wrote in message
news:12d101c4ba7f$b1198870$a301280a@.phx.gbl...
> Hi,
> I have a strange issue. We have a DataTable in MSDE with
> 800 columns. The column name strings are very long.. about
> 200 characters or more.
> When we try to do BULK INSERT into this table, MSDE
> results in a General Network error.
> We use SQLDataAdapter.
> I am working against a very extreme scenario.
> Any help?
> Regards
> Sundari.