I read through your tip on Processing XML files with SQL Server functions. It's great but what happens when the XML file exceeds 4000 charcters? I'm using SQL Server 2005 and the XML file that I try and import is too big.
Do you have any ideas to how I can use SQL to import an XML file that exceeds the 4000 character?
Your input would be greatly appreciated.