For large amounts of XML data you can use Bulk Load of XML Data. See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/htm/bulkload_7pv0.asp?frame=true

>Every example of OPENXML I found store the XML table in a VARCHAR first which has a limit of 8000 characters. Is this the limit of the XML file size that I can send into a store procedure?