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: 164
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