>That would mean a view on a SQL table wouldn't work if it ended up retrieving over 2GB - can that be correct? I'm surprised I haven't heard anyone complain yet...
Yes, I think this is so.
>(and yes, it's millions of records - very few, very small fields)
Pressumably, it wouldn't be a frequent problem, because quite often, if using a view, you would select relevant data, and not all the data.
BTW, you would have the same problem if you select data into a remote view, from a database server that might support many TB or PB of data!
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)