title: Size limit of XML variable in SQL Server 2008
body: <p>I'm passing XML into a stored proc.  I know the max size of the internal binary representation of an XML document is 2GB.  But does this limit also apply to xml variables that be held in memory while the sproc runs?</p>
  
  <p>[EDIT]
  Is the 2GB limit still relevant to SQL Server running in 64-bit mode which can use up to 7 terabytes of RAM?
  [EDIT]</p>