3

I'm trying to import a large XML data-type in SQL Server 2008, but I'm getting the following error message:

Msg 6365, Level 16, State 1, Line 3
An XML operation resulted an XML data type exceeding 2GB in size. Operation aborted.

Does anyone know what I can do to circumvent this / increase the limit in SQL Server? I finally figured out how to import the Data.Stackexchange.com data-dump, but now it's telling me the XML file is too big for the way I'm importing.

using: 

/* Populate the temp table with the comments.xml file */
INSERT INTO #WorkingTable
SELECT *
FROM   OPENROWSET(BULK 'd:\so\comments.xml',SINGLE_BLOB) AS data

If you need any other information lemme know. Thanks!

found this site, hope it's not the best resource out there...

EDIT Thanks to @Bummi it seems this is a restriction in SQL Server. Does anyone know how/if I can get around this?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
d-_-b
  • 21,536
  • 40
  • 150
  • 256

1 Answers1

3

It's limited to 2 GB
Reference Server 2012
SQL Server 2008
SQL Server 2005

bummi
  • 27,123
  • 14
  • 62
  • 101