is there any solution example in MS SQL .
i have a only more than 2 gb xml file .
i am unable to import in my data base .
through the MS SQL .
i am getting the error .
"
Msg 6365, Level 16, State 1, Line 1
An XML operation resulted an XML data type exceeding 2GB in size. Operation aborted.
"
declare @xmlStr xml
SELECT @xmlStr = REPLACE(REPLACE(BulkColumn,CHAR(10),''),CHAR(13),'')
FROM OPENROWSET(BULK 'C:\xmldownload\adzunajobfeeds.xml', SINGLE_BLOB) AS X
select @xmlStr