How much data we can pass through as an XML Text into SP by the concept OPENXML
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql2k5xmloptions.asp
"Limitations
...The size of an XML document that can be stored in 
varchar (max) data type is limited to 2GB. ... "
HTH
