Parameters limited to 900 characters??

[BobWman]

I am using VB 2005 to populate a SQL Server 2000 table with text columns and some columns with data type of varchar(1000). The data is inserted via a stored procedure, using several parameters. Everything works fine as long as the parameter strings are <= 900 characters. But, if I try to pass a string > 900 characters, the field will be empty for that record.

I don't see anything in the documentation about maximum sizes for parameters. What's going on?

 

[NoCoolHandle]

What client are you using?

it sounds like QA.. but I hate to assume that sort of stuff....

Is it vb with ado 2.1 or rdo or are you using dao...

More info needed...!

Rob

 

[BobWman]

I misdiagnosed the problem. The data was being saved. Since the large columns had many lines (CrLf), I was trying to view them with Enterprise Manager (where the rows can be expanded to view multiple lines). Apparently, EM has a 900 character limit on data it will display (seems to be undocumented). The data does show up in Query Analyzer, but you can't read it.

fyi - using VB 2005, ADO.NET 2.0 and SQL Server 2000.

Always something new to learn...

Thanks for responding.