sql varchar(max) issue

I am usin开发者_运维问答g SQL Server 2005 as the back - end for my application. I have given the datatype varchar(max) for a particular column but its storing only 1000 characters. Why is it like that.

---

Its support varchar(max) and it can store more than 1000 character.

I think Mathew you have given the range in insert or update query for this table.

might be in the stored procedure or query you have define the limitations.

---

Random thought: Your intermediate datatypes/conversions are not varchar(max)