why I am unable to define varchar(8001) in sql server 2008

Sep 23 2012 3:51 AM

Hi Experts,

I have a basic doubt. Since varchar(max) supports upto 2 GB data, why I am unable to define varchar(8001). If I have 10000 characters in a column, why should I go for varchar(max), why can't I declare varchar(10000).

Though varchar allocates the memory dynamically, why I am unable to define greater then 8000.

Please give me complete explanation....

Regards,
T.N.Nagasundar.