I have a SQL stored procedure that accepts a parameter of type VARCHAR(MAX). As far as I know and according to all I read about, the max size for such strings is 2GB: MSDN
For some reason when passing a string larger than 8KB I get:
String or binary data would be truncated.
Why do I get this error message, and how can I resolve it?