An excellent script to deal with XML documents that are greater than 8000 characters
Use it like:
DECLARE @hDoc int EXEC usp_OpenXML_From_File 'c:\myXMLfile.xml', @hDoc OUTPUT SELECT * FROM OPENXML(@hDOC, '/rss/channel/item',2) WITH ( title varchar(200), link varchar(400), description nvarchar(2000) )
Republished from http://www.sqlserver-dba.com.