Jim Starkey wrote:

>
> Second, views have nothing to do with the 64KB record limitation. Views
> are handled symbolically and are never actually materialized. The 64KB
> limitation is on physical record size.

Select list size (aka output message size) is also limited by 64K, so
it's pointless to define a wide view if you need to select all its
columns. Also, if a view contains aggregates or unions, then additional
artificial streams are involved and they have their own format which has
the same 64K size restriction as for physical table records.

Both these issues (format and message size limits) also affect stored
procedure inputs/outputs.


Dmitry