Re: Help: 900 byte limit on stored procedure parameter?

Yeah, I also found this problem of visual studio some time.

"ZRexRider" <jerryg@xxxxxxx> wrote in message
news:1144717149.274781.120350@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
The parameters are fine. As I said earlier - everthing in my code and
stored procedures are working perfectly.

The problem was, for some odd reason when you use Visual Studio to view
the table it shows a blank field but if you look at the exact same
field using SQL Server Enterprise you see that the data really is
there.


So the "issue" turns out to be - Microsoft Visual Studio 2003 will not
display the contents of a varchar field that has more than 900 bytes.
And in my case, I tried to fix everything else!!


DickChristoph wrote:
Hi

Have you checked the length of the parameter defined in the .Net
application?

--
-*** Christoph
"ZRexRider" <jerryg@xxxxxxx> wrote in message
news:1144419858.910381.155540@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Thanks Denis - you had my hopes up but nope - this field is not an
index.

I am able to cut and paste any size into this field through SQL
Enterprise Manager . It's just when I try to pass a chunk of data over
900 bytes through a strored procedure parameter.

I hate to build a direct SQL Update into my application but ......




.

Loading