From: aaa@aaa.com   
      
   Thanks. That's what I thought. But when I tried to store an huge xml (around   
   16 m) in the varchar(max), nothing is stored. And no error was raised, do   
   you know why ?   
      
   "Hugo Kornelis"  wrote in message   
   news:dpfta691do0diebmiste68up03gts9q1cp@4ax.com...   
   > On Thu, 7 Oct 2010 17:33:19 -0400, Phil Hunt wrote:   
   >   
   >>Can someone tell me how much data can I store in a colume defined as   
   >>Varchar(max). I am using SQL 2008.   
   >>   
   >>Thanks   
   >>   
   >   
   > Hi Phil,   
   >   
   > The maximum storage size for all ...(max) data type is 2^31-1 bytes. And   
   > since varchar uses 1 byte for each character, that works out to 2^31-1   
   > characters. Or, in decimal form, 2,147,483,647 characters.   
   >   
   > --   
   > Hugo Kornelis, SQL Server MVP   
   > My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)