Posted by SQLMan_25 on 11/22/06 19:53

Hi All,

As per BOL, XML data type can store up 2 GB of data.
My question is when a row is inserted in a table, for its xml column,
2GB of space will be resered.
In other words, how xml is internally stored. Is storage allocation is
similar to varchar(max) data type?

Thanks in advance for everything.

[Back to original message]