Richard M Karpel (5/20/2011)
If the data is store outside the database this is true but according to the white paper found at http://msdn.microsoft.com/en-us/library/cc949109%28v=sql.100%29.asp Then the limitation does exist as stated in this quote:
Storing BLOB data solely within the database (e.g., using the varbinary(max) data type) is limited to 2 gigabytes (GB) per BLOB.
I hate getting answers wrong and went with the SQL only answer, and wish that the question would be qualified as whether stored solely within the database or not.
Other wise a nice challenging question. :w00t:
I can't get your link to work, so can't check what you referenced there, but the question was about Filestream, which is NOT in the database. That's a major part of the whole point for filestream data. That and faster streaming (NTFS stream instead of SQL Server stream).
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon