Permissions for Large Variables to Be Sent Via Stored Procedures (SQL Server)

Posted by Joe Majewski on Stack Overflow See other posts from Stack Overflow or by Joe Majewski
Published on 2010-04-19T16:58:48Z Indexed on 2010/04/19 17:43 UTC
Read the original article Hit count: 142

I can't figure out a way to allow more than 4000 bytes to be received at once via a call to a stored procedure. I am storing images in the table that are around 15 - 20 kilobytes each, but upon getting them and displaying them to the page, they are always exactly 3.91 KB in size (or 4000 bytes).

Do stored procedures have a limit on how much data can be sent at once? I double-checked my data, and I am indeed only receiving the first 4000 characters from the varbinary(MAX) field.

Is there a permission setting to allow more than 4k bytes at once?

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about sql