Size limit of XML variable in SQL Server 2008
Yes it is the same as I read this. http://msdn.microsoft.com/en-us/library/ms187339.aspx
You can store xml instances in a column, or a variable of xml type
and
The stored representation of xml data type instances cannot exceed 2 gigabytes (GB) in size.
Highlights is done by me.
Update The limit is the same for 64-bit OS.